Analyze Folder Contents [Excel Add-In]-VBForums
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
    Super Moderator Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,335

    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.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    When you have received an answer to your question, please mark it as resolved using the Thread Tools menu.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    I dont answer coding questions via PM or EMail. Please post a thread in the appropriate forum section.

    Creating A Wizard In VB.NET
    Paging A Recordset
    What is wrong with using On Error Resume Next
    Good Article: Language Enhancements In Visual Basic 2010
    Upgrading VB6 Code To VB.NET
    Microsoft MVP 2005/2006/2007/2008/2009/2010/2011/2012/Defrocked

  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
  •  



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.