asked on Sending "Command prompt" commands through VBA
How can I send the "Dir" command through VBA so that I can see the result in the Command prompt window of windows Xp, 7 and 8?
Microsoft ExcelVBA
Last Comment
Saqib Husain
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
As those commands leave the window open, and you have to type exit oder close the window manually, I would rather use
Shell "cmd /s /c dir && pause"
With this you only need to press a button to close the window, which is more convenient.
Shell "cmd /s /c dir && pause"
With this you only need to press a button to close the window, which is more convenient.
ASKER
Sorry, never got the chance to even test it, let alone apply it. So probably it is time to close the question now. Thanks
pls try
Open in new window
Regards