Passing focus to another application

[Fred]

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

 

[NickHK]

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

NickHK

 

[rdidentity]

hey

Shell "c:\windows\notepad.exe", 1

will activate your window
here is another states
0 - hide
1 - normal
2 - minimized
3 - maximized
4 - normal size but not focused
5 - minimized and not focused

i hope i have answered your question