Path

[accessman2]

Hi,

Ans1:
MyShortcut.TargetPath = "C:\Program Files\Microsoft Office\Office10\Msaccess.exe "

Ans2:
MyShortcut.TargetPath = "C:\Program Files\..\Msaccess.exe "

The Ans1 works fine.
The Ans2 doesn't work.

I want to work the Ans2, because every user machine's Office path is different.

For example:
MyShortcut.TargetPath = "C:\Program Files\Microsoft Office\Office10\Msaccess.exe "

MyShortcut.TargetPath = "C:\Program Files\Microsoft Office\Office11\Msaccess.exe "

MyShortcut.TargetPath = "C:\Program Files\Microsoft Office\Office12\Msaccess.exe "

MyShortcut.TargetPath = "C:\Program Files\Microsoft Office\Office13\Msaccess.exe "

So, I want to create the link with the target
MyShortcut.TargetPath = "C:\Program Files\...\Msaccess.exe "

How can I do it?
Please let me know, thanks.

 

[KenHigg]

The only way that I can think to do this is to do a seperate table with a workstation fld and path fld. Then enter each workstations name path and retrieve the path from the table as needed with a dlookup()...