Need to open a Spreadsheet via a Macro

[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

 

[Steve Schapel]

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.

 

[Iram]

Thanks Steve!

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




.