Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro
Will a macro in .xls follow your keystroke and open another
application say for example photoshop or some non-windows app. Thanks jc lewis |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro
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 On 20 Jun 2004 16:10:03 -0700, (jc lewis) wrote: Will a macro in .xls follow your keystroke and open another application say for example photoshop or some non-windows app. Thanks jc lewis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming |