RunApp macro Action and Command Line

alienscript

Registered User.
Local time
Today, 04:43
Joined
Jul 17, 2004
Messages
20
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.
 
Why not ditch the macro (they are useless anyway) and use the Shell command in VBA?
 

Users who are viewing this thread

Back
Top Bottom