View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Costanza Costanza is offline
external usenet poster
 
Posts: 3
Default Loop through all open workbooks except Personal.xls

Thanks a lot.

it worked fine




On 5 Maio, 20:18, GS wrote:
Try...

Sub nome_cenario()
* Dim wkb As Workbook
* For Each wkb In Application.Workbooks
* * If Not UCase$(wkb.Name) = "PERSONAL.XLS" Then Call Myproceure
* Next 'wkb
End Sub

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc