Excel - running a cmd line from a cell to cmd/powershell

[Motestfilter]

Hi,

I have a cell with a command on it and would it be possible to be launched to cmd or powershell? I encountered this function,

[FONT=monospace]PID = Shell("notepad c:\MyFiles\TextFile.txt", vbNormalFocus)[/FONT]

but I am not sure how would this launch to cmd or powershell. How would I incorporate the cell with the code on it?

Thanks

 

[Yongle]

The code must be placed in a code module

1. Try adding a shape (eg rectangle) to your sheet, then ...
2. Right-click on rectangle \ click Assign Macro \ click NEW

3. Window opens up containing ...

Sub Rectangle1_Click()

End Sub

4. Paste the code into that procedure

Sub Rectangle1_Click()
[COLOR=#ff0000]    Dim PID
    PID = Shell("notepad.exe C:\MyFiles\TextFile.txt", vbNormalFocus)[/COLOR]
End Sub

5. Go back to Excel with {ALT}{F11}

6. Click on any cell to deselect the shape

7. Click on shape to open the file

If you want it to work differently, then tell us how it should work