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

Ed Adamthwaite

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

Regards,
Ed.
 
Top