I have two versions of Excel on my machine, Excel97 and Excel5.0 .  When I
use GetObject(excel.application) it opens up Excel97 and I want it to open
Excel5.0 instead.  This application will be used by 10 to 15 different
people (each on a different computer) and the exact locations of the 5.0
version 'excel.exe' will differ from machine to machine, therefore
referencing a specific directory location such as
GetObject("C:\MSOFFICE\EXCEL.EXE") will not work for every person.  Any
suggestions?

Thanks,
Mark Mrachek

Hi Mark,

I've heard from folks that I respect that we shouldn't specify the class in
GetObject.  So why not try CreateObject and then open the file?  I don't
know about Excel 5, but in Excel 7 and 8, this should work

Dim objXL as object
    objXL=CreateObject("Excel.Application.7")

    or

    objXL=CreateObject("Excel.Application.5")

If this doesn't work in Excel 5, then try specifying it in GetObject anyways

 GetObejct("XLSFile", "Excel.Application.5")

HTH
--
Dev Ashish (Just my $.001)
---------------
The Access Web ( http://home.att.net/~dashish )
---------------

:I have two versions of Excel on my machine, Excel97 and Excel5.0 .  When I
:use GetObject(excel.application) it opens up Excel97 and I want it to open
:Excel5.0 instead.  This application will be used by 10 to 15 different
:people (each on a different computer) and the exact locations of the 5.0
:version 'excel.exe' will differ from machine to machine, therefore
:referencing a specific directory location such as
:GetObject("C:\MSOFFICE\EXCEL.EXE") will not work for every person.  Any
:suggestions?
:
:Thanks,
:Mark Mrachek

Thanks Dev

I will give it a shot!

Mark Mrachek