Visual Basic for Applications Reference
Too many files (Error 67)
Specifics
There is a limit to the number of disk files that can be open at one time. This error has the following causes and solutions:
MS-DOS operating system: More files have been created in the root directory than the operating system permits.
The MS-DOS operating system limits the number of files that can be in the root directory, usually 512. If your program is opening, closing, or saving files in the root directory, change your program so that it uses a subdirectory.
MS-DOS operating system: More files have been opened than the number specified in the files= setting in your CONFIG.SYS file.
Increase the number specified in the files= setting in your CONFIG.SYS file and restart your computer.
For additional information, select the item in question and press F1.