Moving application windows from Excel VBA

[cherria1]

Hi
Background: Every time my laptop which is connected to 2 DVI monitors goes to sleep, when I wake it, all the application windows have moved around. This means each time I wake it I have to rearrange the windows again.

What I want is a macro that steps through each running application and activates it, sets the Top Left Corner to the top left of the screen (0,0), and sets the window size to (say) 500x500.

Can that be done from Excel VBA?

I have seperately written a macro within Outlook VBA to reposition every open email back to a set position, but I can't see how I control other applications.

Help, it's driving me nuts, and no I have no control over windows settings, it is completely locked down by out company IT policies.

thanks
Andrew

 

[BrianJN1]

Um? So you have three screens? Laptop and two other?

Is this not a windows issue?
I'm not techie, but what does Control Panel tell you about connected devices?

 

[cherria1]

I've tried all the windows routes that is why I have come here to see if there is an Excel VBA workaround. I have no other scripting tools available as it is a locked down setup. Perhaps I shouldn't have given the background and instead:

Is there a way in excel VBA to
1. Identify all active applications
2. set the top left corner and the width and height of each

thanks

 

[cherria1]

Anybody?