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.
 
Back
Top