#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22,906
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort Gavin Excel Worksheet Functions 0 May 17th 07 01:20 PM
My excel macro recorder no longer shows up when recording macro jack Excel Discussion (Misc queries) 1 February 5th 07 09:31 PM
My excel macro recorder no longer shows up when recording macro jack Excel Discussion (Misc queries) 3 February 5th 07 08:22 PM
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet wyndman Excel Programming 2 May 25th 04 06:59 PM


All times are GMT +1. The time now is 02:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"