G
GrannyM
I have Word 2003, Excel 2003 and as of today Excel 2007. In a Word macro, I
am using: Set myExcel = GetObject(, "Excel.application") and if that errors
because Excel isn't open, an error handler with: Set myExcel =
CreateObject("Excel.application")
Now when I run my Word macro even if I have Excel 2003 open, the GetObject
does not find that Excel is open and will go to the CreateObject and create
an instance of Excel using Excel 2007. Is there a way to force it to open
the spreadsheet in Excel 2003?
am using: Set myExcel = GetObject(, "Excel.application") and if that errors
because Excel isn't open, an error handler with: Set myExcel =
CreateObject("Excel.application")
Now when I run my Word macro even if I have Excel 2003 open, the GetObject
does not find that Excel is open and will go to the CreateObject and create
an instance of Excel using Excel 2007. Is there a way to force it to open
the spreadsheet in Excel 2003?