Using the RunApp Macro Command

[John Baker]

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\Sol ution 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

[DCM Fan]

Re: Using the RunApp Macro Command

Use this line instead:

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

[John Baker]

Re: Using the RunApp Macro Command

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
dcmfan@aol.comSPNOAM (DCM Fan) wrote:
[color=blue]
>Use this line instead:
>
>EXCEL.EXE D:\Userdata\IPT \Accounting\Sol ution Sheets\ti1.xls[/color]

[Colleen]

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.

[junkmailspam]

Runapp with Word

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\w inword.exe" "C:\Documen ts and
Settings\Admini strator\Applica tion Data\Microsoft\ Templates\FormL etter.dot"