Excel.Application and Excel version

[Brian Butters]

I have an Access database that uses New Excel.Application to create a new Excel worbook and export data to the worksheet, format it etc. The database is being distributed using XP developer as a run time database. I obviously have Office XP and of course Excel 2002. It seems to be OK with Excel 2000. If a user has Excel 97 will it work? I can't find any property of Excel.Application that specifies a particular Excel version. I know there is a version option in transferspreadsheet .

 

[harra]

If you are using Excel Automation coding (which from your coding it seems to be an accurate assessment), the verion is determined by which Excel Object Library you are bound to in your References. Excel 2002 is Version 10.0, Excel 2000 is Version 9.0, and so on. If you run an Access 2000 database on Access 2002 I have found that it automatically upgrades your reference for you, but I don't know if it goes the other direction.

I believe your code will "break" if you try to run it on a PC that doesn't have the correct version of Excel installed on it.