steve case
Well-known Member
- Joined
- Apr 10, 2002
- Messages
- 823
See http://www.mrexcel.com/board2/viewtopic.php?t=126515&highlight=
My current macro says:
SendKeys "%{tab}^a^c%{tab}"
And it works, but I have to have the user make sure the target application was the last one open before Excel, otherwise [Alt+Tab] will bring up the wrong screen.
I think I want to use the appactivate command so the target application will come up no matter where it was in the sequence of recent events.
VBA Help examples:
*********
Dim MyAppID, ReturnValue
' In Microsoft Windows:
AppActivate "Microsoft Word" ' Activate Microsoft
' Word.
' AppActivate can also use the return value of the Shell function.
MyAppID = Shell("C:\WORD\WINWORD.EXE", 1) ' Run Microsoft Word.
AppActivate MyAppID ' Activate Microsoft
' Word.
**********
are esoteric and Greek to me.
Can someone help me with the syntax?
Dims, Shell functions and AppIDs are throwing me a curve.
The application I want to open is Lotus Notes, the name I see on the dilog box when I press [Alt+Tab] is "Supplier C.A......- Lotus Notes" The "....." stuff between C.A. and Lotus Notes is going to vary.
Help says:
Syntax
AppActivate title[, wait]
But this
******
AppActivate "Supplier C.A."[, wait]
******
doesn't work
.
.
.
My current macro says:
SendKeys "%{tab}^a^c%{tab}"
And it works, but I have to have the user make sure the target application was the last one open before Excel, otherwise [Alt+Tab] will bring up the wrong screen.
I think I want to use the appactivate command so the target application will come up no matter where it was in the sequence of recent events.
VBA Help examples:
*********
Dim MyAppID, ReturnValue
' In Microsoft Windows:
AppActivate "Microsoft Word" ' Activate Microsoft
' Word.
' AppActivate can also use the return value of the Shell function.
MyAppID = Shell("C:\WORD\WINWORD.EXE", 1) ' Run Microsoft Word.
AppActivate MyAppID ' Activate Microsoft
' Word.
**********
are esoteric and Greek to me.
Can someone help me with the syntax?
Dims, Shell functions and AppIDs are throwing me a curve.
The application I want to open is Lotus Notes, the name I see on the dilog box when I press [Alt+Tab] is "Supplier C.A......- Lotus Notes" The "....." stuff between C.A. and Lotus Notes is going to vary.
Help says:
Syntax
AppActivate title[, wait]
But this
******
AppActivate "Supplier C.A."[, wait]
******
doesn't work
.
.
.