View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Tom is offline
external usenet poster
 
Posts: 38
Default GetObject-question

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