I would like to open a command window/prompt (e.g. cmd.exe) and pass a single line command to it, wait for it to finish, and pass another command to it, continuing until done and then close the command window.
Thinking about this, I guess I could build a multi-line command list and pass that to the command window and let it execute, continuing with the VBA once the commands are done executing. However, I would prefer my opening request because it would show how it can actually be done (reuse an open window).
I've found a few things where a single command is run and the window is then closed but it doesn't get reused:
http://www.pcreview.co.uk/forums/run...-t3895036.html
http://support.microsoft.com/kb/129797
I don't know if these are the right track for me or not. I've never had a need to run the command window and execute multiple command from inside Excel so this is a new learning opportunity for me.
Bookmarks