Modified "For Each wbk In Application.Workbooks"

[markx]

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

 

[Guest]

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

 

[markx]

Thanks Tom...
Next time I should think more by myself...