activex error Error -2147417851 "server threw an exception"

[I_Pant]

Hello everyone..
I am stuck in an activex - excel issue and i need help. I have already tried most of the tips provided in the forum but still no luck.
The problem is this: I have the attached vi, slightly modified, and it creates an excel, renames the sheet, on the next iteration it opens the previously created xls and adds another sheet and renames it. I get this error "Error -2147417851 occurred at The server threw an exception." but not always. Sometimes when i delete the file created to run the vi again, it works fine, on my second attempt i get the error again. Weird thing is that when i use the "highlight execution" debugger the problem disappears. I upgraded excel 2000 with SP3, i tried to insert a delay using Flat Sequence Structure but no luck. I tried the MS office homepage but nothing. If anyone can think of something to help please, please let me know.

Labview 7.1, MS Excel 2000 SP3.

Thanx in advance for your time guys..
Yiannis

[I_Pant]

tough one eh??

[Ray.R]

The error comes from LabVIEW using many threads for the activeX objects; and setting it to run in the user-interface thread means that it will only use one thread to manage its activeX objects.

Have you looked at this thread?

http://forums.ni.com/ni/board/message?board.id=170&message.id=302498

Especially Carla's reply:

http://forums.ni.com/ni/board/message?board.id=170&view=by_date_ascending&message.id=302810#M302810

Someone found a solution by updating office with service releases SR-1 and SR-2. The error had stopped after SR-1.

RayR

[I_Pant]

Hello thanx for your answer, but I've tried that already. I upgraded Excel 2000 with sp2 & SP3 and I've gone through the MS web page but no luck.

Thanks for trying anyway...

[MikeS81]

Hi I_Pant,

i made some changes and don´t get your error. Why do you open and close excel between both steps?

See the attached example.

Hope it helps.

Mike

[I_Pant]

Mike thanks for the answer, but i have LV7.1 and I can't run it...

[Jennifer_R]

Hi Yiannis,

Here is the code Mike posted, saved for LabVIEW 7.1. 

[I_Pant]

Jennifer hi and thanks for your help.

A quick question : Did you open the vi at all when you saved it for LV7.1? It gives me two errors when I think it shouldn't..I was wandering if it has anything to do with the differences between Version 8 and 7.1...

Thank you very much for your time...

Yiannis

[MikeS81]

Hi I_Pant,

which errors do you get?

Mike

[I_Pant]

Hello Mike

 It gives two errors one in the "false" case at the Invoke node of Workbook (unwired or bad terminal), and one at the "true" case at the invoke node of workbooks (unwired or bad terminal). It seems to me that it has something to do with the filename you are passing. I am trying to work it out now, the problem is that it looks right to me!.

Anyway Mike I really appreciate your effort, thanx again...