Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I have installed four Excel versions on my pc (97, 2000, XP & 2003). I have written an external vba script, that opens an Excel instance. Now I'd like to test my script with 97, but the script always opens Excel 2003. I'm using the following comand: On Error Resume Next Set oXL = GetObject(, "Excel.Application.8") If Err.Number < 0 Then Set oXL = CreateObject("Excel.Application.8") End If On Error GoTo 0 oXL.Visible = True Any ideas how to open Excel 97? Many thanks in advance! Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Macro/VB Question DDE Question | Excel Worksheet Functions | |||
Controlling Reflection1 from Excel using getObject | Excel Programming | |||
Invoking Excel via Getobject(From Access) to invoke Excel Macro | Excel Programming | |||
Is there a better option than Getobject to access a .xls? | Excel Programming | |||
Excel Getobject error | Excel Programming |