runapp problems

[Guest]

I am trying to run an runapp in conjunction with a larger macro and I
continue to run into the same problem.

It says "Microsoft Office Access can't invoke the application using the
RunApp action. The path to the application is invalid, or a component of the
application is missing. Check the path in Windows Explorer or File Manager."


To my knowledge the path seems correct, but hopefully someone can point me
in the right direction. Here is the path as it is currently stated:

"C:\Documents and Settings\myname\My Documents\BUDGET.XLS"

Thanks!

 

[Steve Schapel]

Drew,

You need to include a rteference to the Excel programme. Something like
this...
"C:\Program Files\Microsoft Office\excel.exe" "C:\Documents and
Settings\myname\My Documents\BUDGET.XLS"

 

[Guest]

Thanks! That worked.
--
Drew

Drew,

You need to include a rteference to the Excel programme. Something like
this...
"C:\Program Files\Microsoft Office\excel.exe" "C:\Documents and
Settings\myname\My Documents\BUDGET.XLS"