PDA

View Full Version : createobject("ExcelApplication") 2010/2013



stanl
03-18-2013, 12:57 PM
I have googled this a lot and found a few posts about renaming file names and other stuff that really screws up the registry.... but

assuming: you have both Office 2010 and 2013 installed. Is there a way when making an ADO call to Excel.Application to specify to load either Excel 2010 or 2013 depending upon the file to be opened?

macropod
03-19-2013, 09:55 PM
If you have Excel 2013 installed, why does it matter which Excel version you open the file with? Excel 2013 can work with earlier Excel versions' files.

Aflatoon
03-20-2013, 06:00 AM
No, it's not - what does ADO have to do with CreateObject("Excel.Application")?