Michael,

You could try something like

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

but couldn't there be more than one?

--

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! I was wondering how to activate the nonactive workbook
open in Excel without naming it explicitly? For instance,
I would like to say Activeworkbooks(generic).activate
instead of Activeworkbooks("July ROI").activate

Thank you so much!

Michael