runapp action to open excel file

G

Guest

I am trying to open an excel file from runapp action of an access macro. the only success i have had is using the argument: "C:\Program Files\Microsoft Office\Office10\EXCEL.EXE" /e which opens the program but not the intended excel file. when i enter the path and file name i get the error message: "The path to the application is invalid, or a component of the application is missing."
 
J

Jim/Chris

Try using this code instead

Call Shell("c:\path to excel app c:\file name", 1)

Jim

-----Original Message-----
I am trying to open an excel file from runapp action of an
Click to expand...
access macro. the only success i have had is using the
argument: "C:\Program Files\Microsoft
Office\Office10\EXCEL.EXE" /e which opens the program but
not the intended excel file. when i enter the path and file
name i get the error message: "The path to the application
is invalid, or a component of the application is missing."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with RunApp 3
runapp problems 2
RunApp 1
RunApp question 2
RunApp giving new error 2
RunApp with a reference to a non EXE command line argument 10
Access Macro RunApp 3
open excel and run a macro from access 1

Top