Running another application from Access 1

[jcarmody]

Hello -

I need to run another application from a Macro.

The command line to run this application is: "c:\program files\pitney bowes smartmailer\WPCM.EXE" -F:"C:\program files\pitney bowes smartmailer\envelope requests\daily scrub\scrub.dbf"

I can use the run app action in my Access macro however the result of this execuition doesn't match the results from when I run the command line through a command line prompt.

I'm wondering if my problem is due to the fact that the run app application runs in the foreground and the macro continues.

Is there a way to suspend the macro until after the app is completed? Would I be better with the shell command. I tried to figure the shell out, but had problems with all of the quotation marks and the -F: parameter.

 

[PHV]

What about this ?
CreateObject("WScript.Shell").Run """c:\program files\pitney bowes smartmailer\WPCM.EXE"" -F:""C:\program files\pitney bowes smartmailer\envelope requests\daily scrub\scrub.dbf""", , True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jcarmody]

Thank-you. It works like a charm.