RUNRMTCMD, run an Excel-VBA-Project

[David Abramowitz]

When running a DOS batch file (.BAT) use the DOS <u>CALL</u> command. e.g. instead of <u>c:windowsmybatch.bat</u> use <u>CALL c:windowsmybatch.bat</u>. This should work (in quotes) with RUNRMTCMD. Dave

[Guest.Visitor]

Also look at the Windows "start" command, especially the "/wait" parameter. Brian

[Guest.Visitor]

Thanks. My first problem works with "CALL" instead of "START" on WinNT. My second problem was that I would not wait on the AS/400 for finishing the remoted PC-job (he will run for several minutes). I have to go ahead, doing my work during that time. Is there a checkbox, a parameter ore something else ? Juergen

[Guest.Visitor]

Dear all, I've written a short VBA-code in Excel. It will be startet with the RUNRMTCMD and works fine in Win95. A RPG has the key, CL is calling the runrmtcmd, a batch takes parameters over and calls excel, excel does its work. Now it should run in the same way with Windows NT/2000. Those are the problems: 1) I will run a batch with parameters. eg: runrmtcmd cmd('"C:my utilitiesabc.bat" "Parameters"') ... Directoryname and parameters could contain blanks. - How to use longer directory names, how with blanks ? - With short directory names I get the parameters but with leading quotation marks. How to solve ? - Calling from AS/400 command line the same runrmtcmd call works better. What's that ? 2) The runrmtcmd doesn't wait to end of pc-job at Win95. Now excel has to be finished. In this case I'm not lucky about it. Thanks for help juergen

[Guest.Visitor]

Brian - Thank you I have used this today in a CL procedure. Tanie Ashton