View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Gunn John Gunn is offline
external usenet poster
 
Posts: 1
Default running vbs script from vba?

I have a vbs script that I'm trying to run from a vba subroutine in excel
using the "shell" function:

cmdstr$ = "cscript w:\simtemp\ctd.vbs"
retval = Shell(cmdstr$, vbMaximizedFocus)

When this executes, the cscript window opens but the script doesn't run.
However when I open a command shell and manually start the script it runs
fine:

Shouldn't this work or am I missing something?

Thanks
John