Difference between excel 2003 and excel 2007 active X programming

[Rashid-Malik]

Would the code written to handle Excel 2003 functionality (e.g. creating, reading, writing excel files) through activeX automation still work for Excel 2007? If not what changes need to be made? Is there an article explaining the changes that need to be made for the excel 2003 code to work with excel 2007 code?
Thanks foe your time!

[MarkBlack]

rashid,

Unfortunatly there is no documentation on the difference or required changes.  I would like you to look at the example Write Table to XL.vi.  This example can be found in the NI Example Finder by searching for ActiveX.

This examples works for both Excel 2003 and 2007.  I recommend comparing this to your own code. 

[smercurio_fc]

The only real source for this information is MSDN, since that's where you will find the ActiveX specification for the various versions of Excel.

[maymaythar]

I Just upgraded my LabVIEW and MS Office to latest version.

It seem my old VI that run on office 2003 does not run for office 2007. 

I also found out that; the example VI come with LabVIEW also does not work for office 2007. Write Table to XL.VI

I received an error "Property Node (arg 1) in Open Excel and Make Visible.vi->Write Table To XL.vi"

Attach is my VI, its simply the modified version of Write Table to XL.vi.

Thanks for viewing my post and Happy New Year!

[ykdoubles]

You may want to repair your Excel 2007 or re-install Office2007.

This problem is usually caused by disorder of the different versions of Office applications.

[maymaythar]

Thanks for the input, I'll try that.

I've treid on two different PC, one running XP and the other running VISTA. Both give me same problem.

I'll also try to play abit with some setting on my PC and office. still abit new to office 2007.