So a new disaster today! I have the following code:
And it actually works - well sort of. If I look at the results in some cases it gives the same file twice (even though there is only 1 in the folder). More worryingly though it seems to miss complete folders at the same level as the ones it returns. As always I feel like I'm doing something wrong. Am I or is this sort od code hit and miss (although it's been missing the same way all day long).
Please Login or Register to view this content.
This will create a a list of folders and files in columns A and B of the active sheet - you can list any other file attributes you need in other columns.....
Please Login or Register to view this content.
Bernie Deitrick
Excel MVP 2000-2010
That seems to work - as in it at least has the first file I know was missing in the original list. CAn you tell me what the difference was?
I think it was because you were processing subfolders first and launching a new FSO for each, which meant that your code would go to the deepest folder in the path, and find the files, then step out one level and reprocess it again - so however many folders you had, you would get that many multiples. I had 7 lisitngs for every file, because I had 7 sub folders in my path. But, I think it never fully processed the lowest level of sub-folder, so those files were missing - you needed to move your files loop outside your sub-folder loop:
Please Login or Register to view this content.
Last edited by Bernie Deitrick; 04-20-2017 at 01:37 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks