Results 1 to 3 of 3

Thread: Analyze Folder Contents [Excel Add-In]

  1. #1

    Thread Starter
    Frenzied Member DKenny's Avatar
    Join Date
    Sep 2005
    Location
    on the good ship oblivion..
    Posts
    1,171

    Analyze Folder Contents [Excel Add-In]

    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.
    Attached Files Attached Files
    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

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Analyze Folder Contents [Excel Add-In]

    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.

  3. #3

    Thread Starter
    Frenzied Member DKenny's Avatar
    Join Date
    Sep 2005
    Location
    on the good ship oblivion..
    Posts
    1,171

    Re: Analyze Folder Contents [Excel Add-In]

    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.
    Attached Files Attached Files
    Declan

    Don't forget to mark your Thread as resolved.
    Take a moment to rate posts that you think are helpful

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width