Help with Print Macro

[ProCad Jen]

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

 

[Steve Schapel]

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"

 

[ProCad Jen]

Oh my goodness, if it had been an alligator, it would have bit me.

Thanks Steve

Jen