Other Open Workbook

[Guest]

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

 

[Tom Ogilvy]

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

 

[Guest]

Tom...Thank U

Tim

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