Opening Excel Documents in a mixed environment

[ladyfrankie]

Good Afternoon,

In the existing database that I maintain, there are a few lines of code that dictate what application is used to open a file type with a specific file extension when a user doubleclicks a field containing a path to a specific file.

I have attached the code. (Code 1.txt)

The problem I have is this, we are currently in a state of transition where some PCs are running Office 2007 and others Office 2003. As a result the statement does not work for Office 2007 users. Some PCs are also running Windows 7 and others Windows XP.

The Access front end is running in Access 2003 and will remain such for the time being. Hence their will always be a present of Access 2003 (Office11 folder on the c drive of any computer) Can someone give me some pointers as to how I can adjust the code to cover all basis?

I have tried a few if statements, but it seems that the code cannot recognise the follow directory of the Office 2007 install on a Windows 7 PC: "c:\program Files (x86)\Microsoft Office\Office12\Excel.exe

Thanks
Ladyfrankie

 

[pbaldy]

I use this:

http://access.mvps.org/access/api/api0023.htm