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...
Results for "file manager"
Download Free File Manager – New Version
Hi Friends, I had created one file manager in Excel using excel macro. Basically it lists all the Files in a folder and sub-folders of any given drive in your PC. It fetches File Name, File Path, File Size, File Type, Last Modified Date of each file and list it in the...
Download Free File Manager in Excel Macro
Hi Friends, I have created one file manager in Excel using excel macro. Basically it lists all the Files in a folder and sub-folders of any given drive in your PC. It fetches File Name, File Path, File Size, File Type, Last Modified Date of each file and list it in...
VBA Guide to Interact with Text Files – Part – 1 of 2
ext files are one of the simplest, lightest file types. This is the reason it is highly used in programming to store a lot of configuration-related data, logs and so many other necessary data...
List All files from Folder and Sub-folders in Excel Workbook
In this article, we are going to learn about how to list the files from folders. Here we will also learn how to list files from subfolders as well. By using File System Object, we can get the list of all Files inside a folder. An important thing to note here is that...
Downloads
FREE Tools & Templates to DownloadMacro Enabled Tool Distance Calculator in Excel This tool is to show how to use Google API to calculate the distance between two places. It is explained here in this article in detail. Download this Excel tool and learn with fun...
List all Folders and Sub-folders in Hierarchical Structure [FREE DOWNLOAD]
Dear Readers, Many of you were looking for a excel tool same as File Manager - which lists down all the files from each and every folders and subfolders, to list down all the folders and sub-folders under a given Main Folder Path. Therefore rather than replying to you...
Excel Tip : How to save an Excel Addin (.xla) to Excel Workbook(.xls)
Hello Friends, This is a small excel tip to convert a .xla or .xlam file to .xls or .xlsm file. This is a simple trick but really helpful one 🙂 A file with .xla or .xlam extension is an Excel Add-Ins file format which can add new modules, extra functionalities, tabs,...
Buy a coffee for the author
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.
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 (=).
VBA: Reverse a string
It is very easy to get the Reverse of a string entered by user in Excel VBA by using VBA inbuilt functionality....
Data Anonymizer: Open Source to Anonymize Personal Data
In the ever-evolving landscape of software development, safeguarding personal data is paramount. Whether you're a...
Custom Excel Formula to Count based on Color
Dear Readers, Last Friday, my wife, Shagun Sharma, who is a Vlogger shared an excel sheet with some data and a problem...