VBA to open cmd window:

[pedie]

Right now whenever i want to run anything I click on Start > type CMD and hit enter.

How can vba directly open up "cmd" window.
I tried this but nope...it does not work

[/FONT]
[FONT=Courier New]Shell:Cmd[/FONT]
[FONT=Courier New]

 

[Glory]

If all else fails you can probably extract what you need from something like this (the fruit of two seconds on Google).

 

[Norie]

This should open the cmd window

ret = Shell("cmd.exe")

Though I'm not sure why you want to do that from VBA - what is it you want to use it for?

 

[pedie]

Norie, that works thanks. There is no purpose as such for now but I just wanted to know how does vba open other .exe windows etc.

Thanks for the help!!!