scripting in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey all

I am trying to get to the Run method of the following object, but I am having problems getting code complete to work. I looked at the example on help and this is where I got the idea. Any ideas

Dim o As Objec
Set o = CreateObject("wscript.shell"
(trying to get o.run to work

Thanks in advance
Rodney
 
Hi Rodney,

Normally one would just build a command line and pass it to the Windows
Shell, e.g.

strCmd = "Wscript.exe MyScript.vbs arg1, arg2..."
Shell strCmd...

If you need your VBA code to wait for the script to complete, use the
"shell and wait" function at www.mvps.org/access.
 
Back
Top