Excel Macro

J

jc lewis

Will a macro in .xls follow your keystroke and open another
application say for example photoshop or some non-windows app.

Thanks
jc lewis
 
G

Gord Dibben

Not while recording.

You have to stick Shell code into the recorded macro.

Example of code to open Internet Explorer........

Sub Internet_Explorer()
Dim taskID As Variant
On Error Resume Next
taskID = Shell("start iexplore.exe") 'enter your command here
If Err <> 0 Then _
MsgBox "IEXPLORE.EXE is not installed on your machine."
End Sub

Gord Dibben Excel MVP
 
Top