LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

When I run the vi "write table to excel" from the active X examples, an error message appears : "error 2147417851.Server generates an exception error"

Is the example for the same version of Excel you have? If not, you must change some ActiveX calls.

Instead of that, check where the error occurs, and see if something is wrong with the property/invoke node command, to see which parameters are accepted, check the object browser in Microsoft Visual Basic For Applications, and look for that command.

Making Excel visible sometimes helps finding problems.

If you don't find any problem, perhaps someone has the sollution, but first you should say which LV version you are using, giving the Windows version too.

Hope this helps
0 Kudos
Message 2 of 5
(2,972 Views)
First, I want to give you some details : I work with the LV 6.02 under Windows 2000.

I'm sure that the example corresponds to the correct version of Excel. The automation open occurs normally and the error appears just after the invoke node "application visible". With the other microsoft products, there is no problem... I don't understand that.
0 Kudos
Message 3 of 5
(2,972 Views)
Try deleting the invoke/property node and rewiring it, be sure that open automation is correctly wired to Excel.Application activeX reference.
Good luck
0 Kudos
Message 4 of 5
(2,972 Views)
Solution:
VI: "Excel_Insert_Table.vi" Replace the first property node "Worksheet.Range" with "Worksheet.Name".
Problem solved!
0 Kudos
Message 5 of 5
(2,922 Views)