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

S

surotkin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

appXL = CreateObject("Excel.Application") 7
How to Reregister a given Excel version 9
Detecting an orphaned Excel.Application 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
How to save and close multiple Excel applications? 1
How to Pause an Excel VBA script without freezing excel 1
Identifying anc saving workbooks from more than one Excel applicat 0
VBA code to modify Excel spreadsheet and then email it 2

Top