Thread: shell command Excel 2007

Hello,

I am trying to use the Shell command and it won't start any command line windows. When I run this

retval = Shell("c:\WINDOWS\system32\cmd.exe", vbMaximizedFocus)

nothing happens and all I get is retval =2644. I don't see the command line Window.
Windows applications like this one work fine and open a Calculator window.

retval = Shell("calc.exe", vbNormalFocus)

What am I to do?

Thanks!
Arijit

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I have added them this time

Your code works for me

Public Sub X()

    On Error GoTo errTrap:
    retval = Shell("c:\WINDOWS\system32\cmd.exe", vbMaximizedFocus)
    Exit Sub
errTrap:
    MsgBox "Could not open cmd.exe.", vbExclamation + vbOKOnly, Title
End Sub

Hey arijit32,

The original code produces "error 76: path not found" for me. Though I am on a corporate computer.

This works for me just fine though:

retval = Shell("cmd.exe", vbMaximizedFocus)

I am sure RoyUK's code works like a charm too!

Then I would think that the problem is with your computer