View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mxp44@yahoo.com is offline
external usenet poster
 
Posts: 3
Default Application.Run for every open workbooks (one by one)

Hi Dave,
Hi John,
Thanks a lot for your answers!

Just for feedback:
The code provided by Dave was almost perfect, I just needed to add
"wbk.Activate", as below:
-------------
For Each wbk In Application.Workbooks
wbk.Activate
Application.Run "'" & wbk.Name & "'!SameMacro"
Next i
------------

On the other hand, I was unable to run your code, John. Suppose I'm
missing something...

Cheers,
Mark