How to write message to command window from VBA?

Question

I have a simple requirement

I want to write 'Hello world' to windows cmd.exe from VBA (excel)

I referred 'Shell' and few other posts but could not do it

Possible duplicate of [Execute a command in command prompt using excel VBA](http://stackoverflow.com/questions/17956651/execute-a-command-in-command-prompt-using-excel-vba) — Phiter, Dec 25 '15 at 12:53
What's the goal? you can use `Shell "cmd.exe /S /K echo Hello World"` — Reza Aghaei, Dec 25 '15 at 12:56
@Reza Yes it worked and in addition to that I also posted my version — Sathish Kumar, Dec 25 '15 at 13:00

score 2 · Answer 1 · edited Dec 25 '15 at 13:12

2

The following worked:

strToPrint = "Hello World!"
Shell "cmd.exe /K echo " & strToPrint, vbNormalFocus

edited Dec 25 '15 at 13:12

Reza Aghaei

answered Dec 25 '15 at 12:59

Sathish Kumar

1 Answers1