{"id":12186,"date":"2014-03-24T23:29:58","date_gmt":"2014-03-24T23:29:58","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/wp\/?p=3230"},"modified":"2014-03-24T23:29:58","modified_gmt":"2014-03-24T23:29:58","slug":"file-manager-add-in","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2014\/03\/file-manager-add-in\/","title":{"rendered":"Download Free Add-in – File Manager"},"content":{"rendered":"

Dear LEM Readers,
\n 
\nIt’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.
\n 
\nHere is the first Add-in which I built it for you to make your life easier. I had already created a File Manager Tool <\/a> <\/strong>in excel an excel workbook.<\/p>\n

About File Manager Tool <\/h3>\n

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:<\/p>\n

    \n
  1. \n

    List Files from a folder<\/a><\/h2>\n<\/li>\n
  2. \n

    New File Manager<\/a><\/h2>\n<\/li>\n<\/ol>\n

    <\/strong><\/p>\n

    Then What is this tool? What is the benefit? <\/h3>\n

    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.
    \nTo 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. <\/p>\n

    After installation of this Add-in you will see an Extra-Tab in your Office 2007 Ribbon named LearnExcelMacro.com<\/strong>. Under this tab you will always find this button to list the files in the selected sheet and cell.
    \n 
    \n\"File
    \n <\/p>\n

    How to install this Add-in in Excel? <\/h3>\n