Open Excel Workbook from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using the RunApp command in a macro, how do I set up the corresponding
command line to open Excel (I have that part: C:\Program Files\Microsoft
Office\Office10\excel.exe), but to automatically open a workbook named
Transfer_Log.xls. I think I need a switch )e.g."/" but can't find the
correct syntax anywhere
 
Does it have to be a macro? It's trivial in VBA: just use the
FollowHyperlink method.

Application.FollowHyperlink "C:\SomeFolder\Transfer_Log.xls"
 
Back
Top