dos command

[peioz]

I have the following batch file :

c:\gs\gs8.13\bin\gswin32c -dBATCH -dNOPAUSE -sDEVICE=pnggray -r300 -sOutputFile=Z:\100R\preview\cl-tech-0010-01.pdf z:\100R\cl-tech-0010-01.pdf

I tried to put this batch into VBA with the Shell command. But I can't get it to work. It seems like the VBA doesn't pass all the switches to dos.
It looks like this.

Shell ("c:\gs\gs8.13\bin\gswin32c -dbatch -dnopause -sdevice=pnggray -r72 -soutputfile=c:\test.pdf Z:\100R\CL-TECH-0010-01.pdf")

I can use the Batch file, but it would be nice to put it all in VBA.....

Is there an easy way to accomplish this ?

 

[BrianB]

I note that sometimes Excel struggles if we give it too much to do in a single line. Try defining your batch command as a separate string and use that in the Shell argument. You may need to explicitly open the adobe .exe file.

Here is a basic working example :-

Sub open_file()
    Notepad = "C:\WINNT\Notepad.exe"
    FileDir = "C:\temp\"
    FileName = "test.txt"
    '------------------------------
    RunString = Notepad & " " & FileDir & FileName
    retval = Shell(RunString, vbNormalFocus)
End Sub

 

[greeny]

is there a way to run dos command like "net send" or "shutdown" by having excel look for the command as a result of formulea? this would be very helpfull to me