Run .vbs file from a macro

[iansa]

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

 

[Douglas J. Steele]

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"