Why my loop stops? - TechRepublic
Question
November 23, 2009 at 10:17 AM
mark.ivanowski

Why my loop stops?

by mark.ivanowski . Updated 16 years, 7 months ago

I have a code to export all codes to a text file. I have to export all codes in several woorkbooks… I use the code below but it stops after executing few files. any help?

Sub callExport()

Dim wkbk As Workbook
For Each wkbk In Application.Workbooks
Call ExportAllModules
Next wkbk

End Sub

This discussion is locked

All Comments