View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_3_] NickHK[_3_] is offline
external usenet poster
 
Posts: 415
Default Passing focus to another application

Fred,
Look at the 2nd argument to Shell.
Possibly you want "vbNormalFocus"

NickHK

"Fred" <leavemealone@home l...
If shell out to another application how can I pass the focus to that
application.
When I run:

Shell "notepad.exe C:\Temp\MyFile.txt"

it starts notepad OK but the focus remains with excel. I want the focus to
goto notepad.

Thanks for any help
Fred