Excel VBA - How to maximize a minimized workbook - the workbook nameis dynamic

K

kazzy

Hi Excel VBA'ers,

I am working with two workbooks (both have current date & time
appended to their filenames every time the macro is run).

One is active and the other is minimized. I need to know how to
maximize the minimized one. I don't know it's filename because the
date & time is appended. So, please, how do I maximize it. I think
solution must be simple but cannot find answer via Google.

Thank you.
 
C

Charabeuh

Hello,

You could try this:

'''''''''''''''''''''''''''''''''''''''''''''
ActiveWindow.ActivateNext
ActiveWindow.WindowState = xlMaximized
'''''''''''''''''''''''''''''''''''''''''''''





kazzy a formulé la demande :
 
K

kazzy

Hello,

You could try this:

'''''''''''''''''''''''''''''''''''''''''''''
ActiveWindow.ActivateNext
ActiveWindow.WindowState = xlMaximized
'''''''''''''''''''''''''''''''''''''''''''''

kazzy a formul la demande :







- Show quoted text -
Click to expand...

Thank you Charabeuh. It works!

Why didn't I come to this forum many hours ago!
 
C

Charabeuh

Hello,

Thanks for your feed back.


_________________________________________________________________
kazzy a formulé la demande :
 
C

Charabeuh

Hello,

Thanks for your feed back.


_________________________________________________________________
kazzy a formulé la demande :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

maximize one of three minimized workbooks to certain sheet 19
Is there a fancy way to open a workbook in a minimized window stat 2
how do i minimize/maximize a workbook from vba? I want to minimize it durring processing to speed th 1
Excel VBA - Using same code to apply to multiple textboxes on Userform 9
Maximize a minimized window from VBA 2
How To Maximize A Window From The Task Bar 4
Close Workbook in Excel 3
Excel VBA - macro that copies the sheets to another workbook 3

Top