Generic Workbook Select
 

Hi! This is a really easy one, but I can't seem to find
the answer. I was wondering what the code is to
generically activate the other open workbook in Excel
without naming it proper. Something like this (but not
this obviously):

Workbooks.Next.Select

Thanks!

Sincerely,

Michael

Generic Workbook Select
 

Hi Michael,

Here is one way

Dim wb
For Each wb In Workbooks
If wb.Name < ActiveWorkbook.Name Then
wb.Activate
End If
Next wb

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Michael" wrote in message
...
Hi! This is a really easy one, but I can't seem to find
the answer. I was wondering what the code is to
generically activate the other open workbook in Excel
without naming it proper. Something like this (but not
this obviously):

Workbooks.Next.Select

Thanks!

Sincerely,

Michael

Generic Workbook Select
 

Activewindow.Activatenext

DR. M


-----Original Message-----
Hi! This is a really easy one, but I can't seem to find
the answer. I was wondering what the code is to
generically activate the other open workbook in Excel
without naming it proper. Something like this (but not
this obviously):

Workbooks.Next.Select

Thanks!

Sincerely,

Michael
.