invoke a VBscript from within a word macro

[tygerc]

hi, all

I'm trying to invoke a vbscipt from within a word macro.

I'm using

RetVal = Shell("C:\docs\binfile.vbs", 0)

however, this gives me an error:

" Run-time error '5':
Invalid procedure call or argument"

Does anyone know how to do this.. if I replace the path of vbscript
with an EXE file, it works fine.. and if I call the vbscript frm the
command line. it also works fine. thanks..

 

[Karl E. Peterson]

hi, all

I'm trying to invoke a vbscipt from within a word macro.

I'm using

RetVal = Shell("C:\docs\binfile.vbs", 0)

however, this gives me an error:

" Run-time error '5':
Invalid procedure call or argument"

Does anyone know how to do this.. if I replace the path of vbscript
with an EXE file, it works fine.. and if I call the vbscript frm the
command line. it also works fine. thanks..

Generally, VBS files need to be fed to cscript.exe or wscript.exe to run...

RetVal = Shell("cscript C:\docs\binfile.vbs", 0)

 

[tygerc]

Thanks Karl. just the stuff I need, thanks so much...

 

[tygerc]

Thanks Karl. just the stuff I need, the only thing I had to
do is provide the full path to cscript.

thanks so much...