I have two loops using Dir$ in vba. If exit the inside loop after an empty string is returned, then make another call to Dir$ with no arguments, the runtime error 5 occurs. Dose anybody know how to solve it?
LLily wrote:
> I have two loops using Dir$ in vba. If exit the inside loop after an empty string is returned, then make another call to Dir$ with no arguments, the runtime error 5 occurs. Dose anybody know how to solve it?
You might consider using the FileSystemObject in the Microsoft Scripting
libary. It's already installed on your tartget machines and is much more
object oriented as well as user friendly. Folder objects support
subfolder and file collections making it much easier to loop through the
contents of any given folder.
--
There are 10 kinds of people: those who understand binary and those who
don't.
