About Excel automation

[Doctor Luz]

Hi

does excel automation deppends on the Excel version?

In other words, If I create an application with excel automation and Access 2007. Will it work on a computer with Access 2003 installed?

Thank you.

[Tom Frohman]

With Excel 2007 the file formats changed so my excel automation programs take forever to run in Excel 2007 because Excel is running in an earlier version compatibility mode. I've had to rewrite programs to work with 2007. Mainly, I just had to change the extensions I used for saving files so that it was working with the newer Excel 2007 format.

When working with previous versions, the number of arguments to some methods changed. For the most part in going from 97 to 2000 to 2003 the programs kept working and with some small tweaks I was able to get them working in all the previous versions.

I've never worked with Access automation so I don't know about that.