How to CreateObject() of a specific version
Posted on 2004-08-02
I have both Office 2000 and Office 2003 installed on Windows XP.
I have an Access 2000 application that uses OLE with Excel 2000.
Since I installed 2003, when I instanciate the Excel object, it always instanciate a 2003 version.
I reference Excel 9.0 library
This is the code I use:
dim oXL as Excel.Application
set oXL = createobject("Excel.Application.9")
debug.print oXL.Version ==> 11.0 !!
How can I force opening the version 9 instead ?