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.
Last edited by DKenny; Mar 29th, 2006 at 12:19 PM.
Declan
Don't forget to mark your Thread as resolved.
Take a moment to rate posts that you think are helpful
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.
Declan
Don't forget to mark your Thread as resolved.
Take a moment to rate posts that you think are helpful