Printable View
Based on some work I did to help Kantalope in alayzing the contents of a folder, see post #8 here, I have created an excel add-in that uses a form to collect user input and generate a report showing the details of all files in a chosen folder, including files in all sub-folders.
The add-in includes a commandbar that allows you to display the form and creat the report.
I found this buried in Office Development and thought it important enough to keep alive, so I've moved it to the CodeBank.
Fine Job.
Based on some feedback from si_the_geek I have made the following changes to the add-in.
1/ The return array is now loaded to the worksheet in a single pass, rather than on a cell by cell basis. This has reduced the procedure duration by approx 35%.
In order to achieve this I had to transpose the array. I have added a function that will transpose any 2D array.
2/ Added some error handling to the Workbook_Open event.
3/ Changed the cursor to an Hourglass while the proc is running, hopefully providing some user feedback.