Other Open Workbook
 

Hi...

I have 10 files I work with...1 being the MASTER file that will remain open
at all times...I open the other 9 files 1 at a time.

Is there any way that when the MASTER file is the one activated to select
the other open file when I don't know its name?

Thank you for you time and support :)

T

Other Open Workbook
 

for each Bk in WorkBooks
if Bk.Windows(1).Visible = True then
if Bk.Name < "Master.xls" then
Bk.Activate
exit sub
end if
End if
Next

--
Regards,
Tom Ogilvy

"MrHappy" wrote in message
...
Hi...

I have 10 files I work with...1 being the MASTER file that will remain
open
at all times...I open the other 9 files 1 at a time.

Is there any way that when the MASTER file is the one activated to select
the other open file when I don't know its name?

Thank you for you time and support :)

T

Other Open Workbook
 

Tom...Thank U :)

Tim

"Tom Ogilvy" wrote:

for each Bk in WorkBooks
if Bk.Windows(1).Visible = True then
if Bk.Name < "Master.xls" then
Bk.Activate
exit sub
end if
End if
Next

--
Regards,
Tom Ogilvy

"MrHappy" wrote in message
...
Hi...

I have 10 files I work with...1 being the MASTER file that will remain
open
at all times...I open the other 9 files 1 at a time.

Is there any way that when the MASTER file is the one activated to select
the other open file when I don't know its name?

Thank you for you time and support :)

T