Using VBA variables in MS DOS
Posted on 2009-05-10
Hello, I would like to take variables from a VBA form and insert them into a series of DOS commands. For example, the program would open a MS DOS window using
Call Shell("cmd.exe" & dosCmd, vbNormalFocus)
then I would like text field1 from the form inserted into the MS DOS command line and a return command. This would be followed by text field2 from the form inserted and a return command supplied.
This will go on until all the user supplied information from the form have been entered into MS DOS. I am not sure how I can carry over these variables into MS DOS and how to execute the line.