none
Code to retrieve files from a folder based on certain conditions and display them in an excel worksheet RRS feed

  • Question

  • Hi all,

    Please I am totally new to VBA and i'll apreciate any help in showing me some code that will retrieve file names from a folder based on certain conditions, and display them in an excel worksheet. The conditions are below:

    1. Extract file names of files that contain embedded macros within them.

    2.Extract files that exceed the size of 15 MB

    3. Extract files that contains external data connections

    4. Extract files that contains references to external links

    Thank you so much, I'm hoping for some very helpful responses.

    • Moved by Youen Zen Tuesday, June 26, 2012 8:20 AM To provide better support (From:Visual Basic General)
    Monday, June 25, 2012 5:42 PM

All replies