activex error Error -2147417851 "server threw an exception"

[Jennifer_R]

Hi Yiannis,

The code ran fine for me with LabVIEW 7.1 and Microsoft Excel 2007.  The only change I made was to the base path, saving the file to a different location on my computer. 

Which invoke nodes cause errors?  Have you tried different or additional inputs where there is a notice about an unwired or bad terminal? 

[I_Pant]

Hello Jennifer thanks for the reply. I am working on it for two days now, but no luck...

May be i should upgrade excel???

I don't know, I'll let u know my progress..

Thanks again

[I_Pant]

Well I have to admit that sometimes you need a bit of luck..

I deleted and created new invoke nodes exactly the same as Mike had done in his code. I wired them as in Mike's vi and the vi runs fine! No error...

I want to thank anyone who helped Especially Mike and Jennifer. If possible and if any of you guys have time I would like to know what did i do wrong in my first vi. It is good to know what was the problem...

Anyway guys thanks again looks like the problem is solved...

cheers

Yiannis

[Jennifer_R]

Hi Yiannis,

It's hard to say if there was a particular change that eliminated the error, or if it was a combination of factors.  The main differences I noticed are the placement of the Close Reference functions, the use of To Variant, how the filename is specified, and setting SaveChanges to False when closing the workbook. 

I'm glad to hear that everything is working now!