How to open a specific version of Excel from Access?

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.
 
G

Guest

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

How to return user to Access after getting Excel worksheets 2
Open a New Instance of Excel 3
Trying to print specific worksheet from outlook attachment 2
Open a specific Excel Workbook 3
How to Cancel the Protect of Excel with VB and save it with a new password again 1
Open a Macro Enabled Worksheet from Access 2
From Access Automate Excel to transfer cell values to form controls - possible? 6
Access Command to run access, open to specific form and specific record 1

Top