View Full Version : RunApp macro Action and Command Line


alienscript
09-05-2004, 07:51 PM
After I executed my RunMacro and I subsequently want to open an Excel spreadsheet from Access application.
I use RunMacro to select macro Action "RunApp" and in the Action Arguments Command line I typed "C:\Stocking Status\template.xls" /excl

I execute the RunApp and received this error message, "Microsoft Access can't invoke the application using the RunApp Action. The path to the application is invalid, or a component of an application is missing".

What went wrong?
Appreciate and many thanks if someone can please help me with this.

I'm using Access 2002.

Mile-O
09-07-2004, 02:12 AM
Why not ditch the macro (they are useless anyway) and use the Shell command in VBA?