By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 862 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

Using the RunApp Macro Command

P: n/a
Hi:

I am attempting to set up a process in Access that calls a spreadsheet, executed the macro
in the spreadsheet, and then returns control to the next line of the macro in Access.

I am not even getting to first base.

The command I am using is : RunApp, with the path parameter:
D:\Userdata\IPT\Accounting\Solution Sheets\ti1.xls

I know this path is correct, but I am getting back an error that says:
Microsoft Access Cant invoke the application using the RunApp Action.
The path to the application is invalid.

The application is in the same folder as the Access application, but it just does not
appear to be finding it. Is it case sensitive? I have all the cases and things right.

Can anyone offer pointers?

Regards

John Baker
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Use this line instead:

EXCEL.EXE D:\Userdata\IPT\Accounting\Solution Sheets\ti1.xls
Nov 12 '05 #2

P: n/a
Thanks:

Since they were all in the same folder (directory) I found i could also use

Excel.exe ti1.xls

Thanks again.. a little change but SOOO important!

Regards

John Baker
dc****@aol.comSPNOAM (DCM Fan) wrote:
Use this line instead:

EXCEL.EXE D:\Userdata\IPT\Accounting\Solution Sheets\ti1.xls


Nov 12 '05 #3

P: 1
Hi,
Can you help me with this one -- I am able to open other applications with the runapp macro, but am unable to open word. Any suggestions?
Thanks.
Apr 27 '06 #4

P: 1
Hi,
Can you help me with this one -- I am able to open other applications with the runapp macro, but am unable to open word. Any suggestions?
Thanks.
You need to separate the two sections of
the command line (i.e. the application program file and the document).

"C:\Program Files\Microsoft Office\Office\winword.exe" "C:\Documents and
Settings\Administrator\Application Data\Microsoft\Templates\FormLetter.dot"
May 12 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.