runapp action to open excel file

  • Thread starter Thread starter Guest
  • Start date Start date
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."
 
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
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."
 
Back
Top