How to send “Enter” key to cmd window from VBA script

[yarondavid]

Hi

I want to send and "Enter" key to the cmd window from VBA script

I use the following line in VBA script, but it doesn't work:
Call Shell("cmd.exe /K t:" + Chr$(13), vbNormalFocus)

Thanks,
Yaron

 

[Andrzejek]

Hav you tried:

SendKeys "ENTER"

or

SendKeys "~"

Have fun.

---- Andy

 

[yarondavid]

The following code still doesn't work:
Call Shell("cmd.exe /K t:" + SendKeys("ENTER"), vbNormalFocus)

I get a Compile error message

 

[Andrzejek]

No, you don't do that

Try:

Call Shell("cmd.exe, vbNormalFocus)[green]
'or whatever runs your cmd window [/green]

SendKeys "~" [green]'send Enter to your cmd[/green]

Have fun.

---- Andy