Hi,
I'm attempting to code a macro that will allow me to launch a dos program and input parameters.
Initally I have a userform that the user can put variables into.
I then want to take these variables and use them as a string for with the dos program.
I'm attempting to use the "send keys" function, but am not having any joy with this at all.
Except "Help me" would be:
myProgram myOption1 myOption2 myOption3
One workaround I could do is to create batch files, but I see this as a messy solution that I want to avoid.
Everything is fine, apart from getting dos to accept keys......
Has anybody got any advice on how to do this?
I'm attempting to code a macro that will allow me to launch a dos program and input parameters.
Initally I have a userform that the user can put variables into.
I then want to take these variables and use them as a string for with the dos program.
I'm attempting to use the "send keys" function, but am not having any joy with this at all.
Code:
Shell "C:\Windows\System32\cmd.exe", vbNormalFocus
SendKeys ("Help me")
Except "Help me" would be:
myProgram myOption1 myOption2 myOption3
One workaround I could do is to create batch files, but I see this as a messy solution that I want to avoid.
Everything is fine, apart from getting dos to accept keys......
Has anybody got any advice on how to do this?