Access Macros

[Gary L. Steward]

Is there a command within a macro that I can use to start another application
such as Excel and open a specific document on the same computer.

ie excel.exe f:\excel docs\attendance.xls

 

[Steve Schapel]

Gary,

The Access macro action for this is RunApp. The Command Line argument
would work like this I think:
"Excel.exe" "F:\excel docs\attendance.xls"
.... though I always prefer to spell it out fully:
"C:\Program Files\Microsoft Office\...\Excel.exe" "F:\excel
docs\attendance.xls"

 

[Gary L. Steward]

Thanks, I had forgotten was the quotes around the desired file. You are a
good man Charlie Brown.