error -2147417851 for example write table to XL

[Edith]

Hi, I want to save array data into excel. I try the example    write table to XL.vi 

but error -2147417851 comes out 

I have no idea to solve this error.

Can anybody help?

Thank you very much!

[nyc_(is_out_of_here)]

Please attach the VI you are using.

[ben64]

The example vi works fine (LV2009 with Excel 2003). What Excel version do you have installed on you machine?

Ben64

[Edith]

Oh, here is the example

[Edith]

It is work fine in another machine with LV 2010 and Excel 2007.

But for this machine with LV 7 and Excel 97 there is an error,and i don't know why.

[smercurio_fc · Accepted solution]

Each version of Excel has its own object reference, and Microsoft has made changes to some of the classes with each version of Excel. Thus, it is highly likely that an example will work with one version of Excel, but not another since the properties and methods will have changed. The only thing you can do is that you have to look at the documentation for the Excel object model on MSDN to see what's different.

[Edith]

Oh, yes  I upgrade excel to 2007, still using LV7.1, it works.

Thank you so much!