Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have written the following code that opens the files in
a directory, then performs some manipulations, and saves the file: Do While NameOfFile < "" Application.EnableEvents = False Workbooks.Open (CurDir & "\" & NameOfFile) Application.EnableEvents = True .... Workbooks(NameOfFile).Close savechanges:=True NameOfFile = Dir() Loop What puzzles me is that the loop runs 48 times, then stops without reason. Is there some limitation on how many times the dir() command can be run? File 49 is in no way different to the other files. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
When IF has limited iterations | Excel Discussion (Misc queries) | |||
limited usage | Excel Discussion (Misc queries) | |||
VLOOKUP is very limited | Excel Worksheet Functions | |||
Help! IF function is too limited | Excel Discussion (Misc queries) | |||
Limited Sumif | Excel Discussion (Misc queries) |