Help with Print Macro

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

Guest

Hi, it's me again.

I am building a macro that will export certain information to a specific
Excel spreadsheet. So far, I have the export working, and I can open the
Excel Application. How do I get it to open a specific Excel file, instead of
just a blank worksheet?

This is what I have so far:

Action: RunApp
Command Line: C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE

I want it to open: G:\Admin\Jen's Projects in Progress\Jenish Access
Project\Forms for Project.xls

Do I add to the command line?

Jen
 
Jen,

Yes, just add it to the end of the Command Line argument, with the two
sections separated by a space, and enclosed in ""s, so the Command Line
looks like this...
"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" "G:\Admin\Jen's
Projects in Progress\Jenish Access Project\Forms for Project.xls"
 
Back
Top