I have asked this same question on the Access board. I hope I am not violating any forum rules.
If I wanted to open Excel.exe on a user's machine, how can I know the exact path to the Excel.exe file.
I want to open Excel.exe from a batch file like:
C:\Program Files\Microsoft Office\Office11\Excel.exe
but the path may be different for some users. It could be Office10 or some other difference.
What VBA code can I use in order to always know the correct path to the latest version of Excel or Access?
Thanks,
David
If I wanted to open Excel.exe on a user's machine, how can I know the exact path to the Excel.exe file.
I want to open Excel.exe from a batch file like:
C:\Program Files\Microsoft Office\Office11\Excel.exe
but the path may be different for some users. It could be Office10 or some other difference.
What VBA code can I use in order to always know the correct path to the latest version of Excel or Access?
Thanks,
David