Recursing Directories using the Win32 API to overcome the limitations of DIR$
For some time a friend of mine has been writing a number of utilities that sit inside Excel that need to recurse directories for information. He has used the DIR() function and we found that it doesn't like being called multiple time on the stack. We worked around this by storing the sub-directories that needed… Read More »