Need to open a Spreadsheet via a Macro

  • Thread starter Thread starter Iram
  • Start date Start date
I

Iram

Hello,

I have a macro with several actions. There is an action that I need and that
I can't figure out.
How can you set it to open a particular Spreadsheet?

This is the location of the Excel executible
C:\Program Files\Microsoft Office\Office11\EXCEL.exe

This is the location of the Excel File that I need to open
S:\Databases\Santa Barbara Case Mgmt Tool\Excel Reports\Counting What
Counts\Performance Goals.xls

Can you help me with this?


Thanks.
Iram/mcp
 
Iram,

Use a RunApp action in your macro. In the Command Line argument, just enter
the path/file of your file - Excel should be used automatically to open it.
 
Thanks Steve!



Steve Schapel said:
Iram,

Use a RunApp action in your macro. In the Command Line argument, just enter
the path/file of your file - Excel should be used automatically to open it.

--
Steve Schapel, Microsoft Access MVP




.
Click to expand...
 
Back
Top