Add reference to Graph.exe for different versions of ms office

[mpalazzo]

I'm doing some graph manipulation in VBA, and have made a reference (and am using successfully) the Graph.exe for MS Office. My problem is that I can't be sure exactly what version of Access my end users will be using--or more precisely where their Graph.exe lives. So for some, the reference will point to C:\Program Files\Microsoft Office\OFFICE11\Graph.exe and for others it might be C:\Program Files\Microsoft Office\OFFICE10\Graph.exe. Also what if they didn't install Office to its default location? I'm compiling and releasing an .mde file, but aren't sure how to get around this problem. Thanks in advance, Mike.

[MMcCarthy]

I'm doing some graph manipulation in VBA, and have made a reference (and am using successfully) the Graph.exe for MS Office. My problem is that I can't be sure exactly what version of Access my end users will be using--or more precisely where their Graph.exe lives. So for some, the reference will point to C:\Program Files\Microsoft Office\OFFICE11\Graph.exe and for others it might be C:\Program Files\Microsoft Office\OFFICE10\Graph.exe. Also what if they didn't install Office to its default location? I'm compiling and releasing an .mde file, but aren't sure how to get around this problem. Thanks in advance, Mike.

Hi Mike

You can use this function triggered in a suitable location to determine the version of Access being used. Then use a SELECT CASE statement to determine the path to the Graph.exe

Function GetVersion() As String
     GetVersion = SysCmd(acSysCmdAccessVer)
 End Function
 

Something like the following for the SELECT CASE statement ...

Dim version As String
 
    version = GetVersion
 
    SELECT CASE version
 
    Case "10.0"
        path = "C:\Program Files\Microsoft Office\OFFICE10\Graph.exe."
    Case ....etc.
 
    END SELECT
 

These are the versions:

8.0 = Access 97
9.0 = Access 2000
10.0 = Access 2002(XP)
11.0= Access 2003
12.0= Access 2007