RunApp Help

[labbadabba]

Hello again all,

I don't know why I'm having such a problem with this but... I'm simply trying to open a .xls using a RunApp Macro. In MS help it says that I need the file path. I put that in and it doesn't work. I tried putting brackets, quotes. parentheses, still nothing. My file path is as follows:

C:\Documents and Settings\ta26980\My Documents\Excel Docs\ACS Actions.xls

Any thoughts. Thank you all for your help and help in the past!

Ty

 

[ghudson]

The RunApp action has the following argument:

The command line used to start the application (including the path and any other necessary parameters, such as switches that run the application in a particular mode). Enter the command line in the Command Line box in the Action Arguments section of the Macro window. This is a required argument.

You can't run the RunApp action in Microsoft Visual Basic. Use the Visual Basic Shell function instead.

You have to supply the command to open the Excel program and also the file you want opened. Like this...

"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" "C:\Temp\Test.xls"

Too many reasons to list but you should be using the Shell() function or my favorite... the ShellExecute method using VBA instead of a macro.

Check out this thread... Opening a file