Download Free Add-in – File Manager

Excel Macro | Excel Macro Tutorial | Interesting VBA Functions | Popular Articles

.

Dear LEM Readers,
 
It’s been long time since I wrote any article here. I was really busy in some personal work and apology for not making it. Now I am back with some more tutorials, articles, tools and Add-ins.
 
Here is the first Add-in which I built it for you to make your life easier. I had already created a File Manager Tool in excel an excel workbook.

About File Manager Tool

This tool used to list down all the files from your selected drive or folder/sub-folder. It also list down specific type or types of files (if you need). To know more about this tool read the below articles:

  1. List Files from a folder

  2. New File Manager

Then What is this tool? What is the benefit?

To list all files from a folder, you always need to open the above file and you can list the files only in that Workbook. You can not use the above code in any other workbook or worksheet.
To overcome above drawback, I created one Add-in. This will help you in listing the files in any Worksheet from the selected cell. It means now you have freedom to list your files in any excel sheet in any specific range.

After installation of this Add-in you will see an Extra-Tab in your Office 2007 Ribbon named LearnExcelMacro.com. Under this tab you will always find this button to list the files in the selected sheet and cell.
 
File Manager - Add-in Installed
 

How to install this Add-in in Excel?

  • 1. First download this add-in file
  • 2. Open A New Excel Workbook
  • 3. Go to Excel Options (as shown in below Image
     
    File Manager - Excel-Options
     
  • 4. Go to Excel Options (as shown in below Image

     
    File Manager - Excel-Add-in
     

  • 5. Now Browse the add-in where you have downloaded the add-in file
     
    File Manager - Browse Add-in
     
  • 6. Click on OK
  • 7. Now you are done. Add-in is installed. Now whenever you open any excel workbook you will will see a new Tab in the Ribbon as shown below:

    File Manager - Add-in Installed

How it works?

On clicking on “List Files from Folder” button under “LearnExcelMacro.com” tab following dialog box will open:
 
List-File-Dialog-box

 

Select your option and click on List Option button and Files will be listed from the selected folder as shown below:
 
File Manager - File-List

 

Enjoy using this FREE Add-in. Do let me know your feedback

 

Download Now

 

Related posts:

  1. List All files from Folder and Sub-folders in Excel Workbook
  2. Download Free File Manager – New Version
  3. List all Folders and Sub-folders in Hierarchical Structure [FREE DOWNLOAD]

Buy a coffee for the author

Adsense

Download FREE Tools and Templates

There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.

Hurray..Lets Go
Convert PDF Tables to Excel with VBA | Step-by-Step Guide
Convert PDF Tables to Excel with VBA | Step-by-Step Guide

Dec 4, 2024

Convert PDF Tables to Excel with VBA | Step-by-Step Guide How to Convert PDF Tables to Excel Using Excel VBA (Macros) Extracting data from PDF tables into Excel can be tedious, but with Excel VBA (macros), you can automate this process and save time. This guide will...

Dynamic Arrays and Spill Functions in Excel: A Beginner’s Guide
Dynamic Arrays and Spill Functions in Excel: A Beginner’s Guide

Feb 9, 2024

In today's tutorial, we'll be diving into the exciting world of dynamic arrays and spill functions in Office 365 Excel. These features have revolutionized the way we work with data, providing a more flexible and efficient way to handle arrays. I am going to explain...

How to Declare a Public Variable in VBA
How to Declare a Public Variable in VBA

Feb 3, 2024

While programming in VBA sometimes you need to declare a Public Variable that can store the value throughout the program. Use of Public Variable: Let's say you have 4 different Functions in your VBA Code or Module and you have a variable that may or may not be...

What is Excel Formula?

Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).

Know more

You May Also Like…

9 Comments

  1. Rudra Sharma
    Rudra Sharma on March 25, 2014 at 6:47 am

    Thanks Vishwa,

    I did install this add in is working like a treat. Thanks for sharing this. I really felt your absence in LEM. Hope your personal work is over and will continue to quench our thirst of excel and VBA tips.

    With Warm Regards

    Rudra Sharma

    Reply
    • Vishwamitra Mishra
      Vishwamitra Mishra on March 25, 2014 at 6:52 am

      Thanks Rudra and sorry for making my readers to wait!!
      Yes, now you will get Excel VBA tips, Articles and tools regularly.

      Reply
  2. Narendra
    Narendra on September 30, 2014 at 4:18 pm

    Hi Vishwa,

    Can you provide an article for how to make such addins?

    Thanks
    Narendra

    Reply
  3. Henny Kerkhoff
    Henny Kerkhoff on December 15, 2014 at 1:33 pm

    Y want to use your File-Manager.
    all files go well
    but selecting a singel file gives no result

    Reply
  4. Htun Htun Oo
    Htun Htun Oo on July 5, 2018 at 12:20 pm

    Thank you so much.

    Reply
  5. Hoang Huu Cong
    Hoang Huu Cong on November 6, 2018 at 12:47 pm

    Thank you!
    But function On clicking on “List Files from Folder” button under “LearnExcelMacro.com” tab following dialog box will open inactive on excel 2010 and excel 2016. Can you help, please!

    Reply
  6. Syed baba
    Syed baba on July 23, 2019 at 2:44 am

    Can you please Post the video to File manager

    Reply
  7. kumar shanmugam
    kumar shanmugam on September 17, 2021 at 12:53 pm

    Will it work faster for more than where it has to list more than 50000 list

    Reply

Trackbacks/Pingbacks

  1. Excel VBA Code to List files from Folder and Sub-folders in Excel Workbook - […] in Hierarchical Structure [FREE DOWNLOAD] How to create folders in windows via Excel VBA Download Free Add-in – File…

Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Join and get a FREE! e-Book

Don't miss any articles, tools, tips and tricks, I publish here

You have Successfully Subscribed!

Pin It on Pinterest