How to force VBA to create an Excel.Application object of specified version of Excel?
 

Hello everyone,
I have many versions of MS Excel installed on my PC.
I use VBA code to create an Excel.Application object from MS Access and
do some other stuff.
Recently I installed MS Excel 97. After that I got an error. I traced
execution and found out that VBA creates Excel.Application object of MS
Excel 97 version, nevertheless I use a link to Microsoft Excel 11.0
Object Library.

Does anybody know how to set a default version of Excel.Application
object to Excel 11.0?

Thanking you in advance.
surotkin


--
surotkin
------------------------------------------------------------------------
surotkin's Profile: http://www.excelforum.com/member.php...o&userid=21197
View this thread: http://www.excelforum.com/showthread...hreadid=480872