Excel not calulating formula, so when I go to read the cell with the formula in it I get an error

[acalmeyn]

I found out how to make it work using Active X. What I did was disable the two tool options that I needed in excel to covert dex2hex. I would reenable the same two tool options. This must have triggered excel to recalculate the sheet and then all my dex2hex conversion were OK.

[jurroppi1]

I see. I thought you were tying to overcome the issue without having to manually change settings in Excel. I tried doing this with ActiveX (installing the addin), but it didn't work for me. Can you tell me, did you actually set the installed property to false and then true again in your LV code, or did you actually use the tools>addins menu in excel to perform the task manually? I am performing this task multiple times, and I had to find a solution that didn't involve manually changing things in Excel or having to leave Excel open by manually opening it prior to running the LV app that was running.

[acalmeyn]

Here are the VI's I used. I was using Excel 2000 with Window XP. Hope this helps if not you can email me (see notes in the VI).

[acalmeyn]

Sorry I forgot to answer your question. The VI will install and uninstall the toolkit automaticlly. The user doesn't even know that excel is being used. Which can be a problem if the user opens excel why you are using it in your program your program will error out.

[jurroppi1]

Understood perfectly, thanks for the file! I did re-read youre response to me above, and figured you had done what you did, but I do appreciate you posting the code.

Thanks again,

Jason