This post is concerning a VBA excel macro submitted by Brettdj entitled "List file attributes of directory and sub-directories".
I've run this macro in Excel 2007 and it exhibits the following behavior:
1. It will traverse the directories and collect data as expected.
2. However, when there is no further directory and file information it continues on and fills in the all other rows of the spreadsheet up to row 983054 with the text "#N/A"
I'm not sure why this is happening and I haven't yet tried the same macro in and older version of office.
Any ideas?