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

[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.

 

[Charabeuh]

Hello,

You could try this:

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





kazzy a formulé la demande :

 

[kazzy]

Hello,

You could try this:

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

kazzy a formul la demande :







- Show quoted text -

Thank you Charabeuh. It works!

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

 

[Charabeuh]

Hello,

Thanks for your feed back.


_________________________________________________________________
kazzy a formulé la demande :

 

[Charabeuh]

Hello,

Thanks for your feed back.


_________________________________________________________________
kazzy a formulé la demande :