How to open a specific version of Excel from Access?

  • Thread starter Thread starter Ed Adamthwaite
  • Start date Start date
E

Ed Adamthwaite

Hi all,
I have just installed Office 2007 beta2 and the registry settings will not
change back from Excel12 (2007) to Excel9 (2000) if I open a file in Excel9.
Word12 with Word9 works well, no problems.

What happens is that if I have "Dim xlApp As Excel.Application" or "Set
xlApp = New Excel.Application", Excel12 is what gets activated, even though
it's the Excel9.olb library that is referenced.
I'd like to force it to open Excel9.

Thanks for any responses.

Ed Adamthwaite.
 
Thank you onedaywhen,
a great link with excellent detail. Just what the doctor ordered.

Regards,
Ed.
 

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

Automating excel from MAccess 2007 8
excel from access 2
How to pass parameters to excel from wscript (Windows script) 5
Run code in Excel from Access 4
How can I copy 10 worksheets from a single workbook to a single ac 2
Opening Excel files from Access 2000 1
excel to access problem 1
Setting a reference to a libray in code 9

Back
Top