mgroyal
asked on
sendkeys for windows key + m ???
Hi
Actualy I couldn't find something like 'sendkeys winkey+m' on the net. May be there's another way using ASCII-Codes or so... Anyway the object is to minimize all application windows. Please note that I'm programming in excel and that I want to minimize all application windows not the workbooks-windows...
*mg
Actualy I couldn't find something like 'sendkeys winkey+m' on the net. May be there's another way using ASCII-Codes or so... Anyway the object is to minimize all application windows. Please note that I'm programming in excel and that I want to minimize all application windows not the workbooks-windows...
*mg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
hearing...
After call vinnyd's code,
application.WindowState=xl Normal
application.WindowState=xl
ASKER
Hi,
I tried the API-Code but it isn't working. I receive the follow error-message:
Compile error: Only comments may appear after End Sub, End Function, End Property..
What I need to do?
I tried the API-Code but it isn't working. I receive the follow error-message:
Compile error: Only comments may appear after End Sub, End Function, End Property..
What I need to do?
ASKER
the code is working... Thx Vinnyd
Unfortunately my idea with win+m isn't working. Actually I've a window from an other application for which I need to have the focus.
For example: I have window called PS/nVision. Is it possible to control this window over its name? (API)
I'll double the point if there is a solution for this.
Thx mg
Unfortunately my idea with win+m isn't working. Actually I've a window from an other application for which I need to have the focus.
For example: I have window called PS/nVision. Is it possible to control this window over its name? (API)
I'll double the point if there is a solution for this.
Thx mg
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.