For Each wbk In Application.Workbooks
if wbk.Name < thisworkbook.Name then
<do something
end if
Next wbk

--
Regards,
Tom Ogilvy



"markx" wrote:

Hello there,

One more "telegraphical" question...

If I want to make changes in all open workbooks, I use something like:

For Each wbk In Application.Workbooks
<do something
Next wbk

Now, my question is:
how to write the macro that will <do something on all the open workbooks
except the one from which the macro is executed?

Many thanks for your help on this,
Mark