Run .vbs file from a macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

iansa - 29 Oct 2004 13:28 GMT

I am trying to run a .vbs file from an access macro using RunApp. Is this
possible?

If not is there an alternative. I'd like to keep it all in access as it is
the last in several steps in the macro.

Thanks in advance for any help

ian

Reply to this Message

Douglas J. Steele - 29 Oct 2004 13:33 GMT

You need to call wscript.exe (if it's interactive) or cscript.exe (if you
just want to run it in batch).

In other words, you need

wscript.exe "C:\My Scripts\testing.vbs"

rather than simply

"C:\My Scripts\testing.vbs"

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> I am trying to run a .vbs file from an access macro using RunApp. Is this
> possible?
[quoted text clipped - 5 lines]
>
> ian

Reply to this Message