List Files In Folder & Subfolders Using DIR

[VijaySM]

@snb - I use excel in office and want to learn vba as it reduces many of my repeated tasks. I want to take the list of files and folders in a network path with large number of files. If I do this manually, it will be a very difficult and repetitive work. I tried vbscript but it is also slow and not get all the details. I searched for this from web and got many code snippets, used them and compared and I found the above 2 codes very useful. The 2nd code is slightly faster and hence I tried to modify it similar to 1st code. I was unable to modify as it uses array and I am getting error. So I posted it here as I saw many users have asked similar questions. I found one similar thread to get the details of mp3 files but again I could not modify it for any file type. The answer given in other forum to use CMD shellobject give results but is also very slow.

http://www.ozgrid.com/forum/showthre...97743&p=761097

Regarding the error handlers, I run the codes on my local computer and see if there are any errors and how the results are displayed and change some code and see how the output is got. As a hobby, I like to search the web and test the codes for doing similar tasks and very much like working with lists.

Thank You
VijaySM

[VijaySM]

Hi Excel Experts

Any response regarding the above question. Also, If the folder length exceeds 260 characters as some files downloaded from web have more than 260 characters, Dir throws error "file not found". My question to this error is whether a workaround can be made and code should not skip the folder or file.

Regards
VijaySM