Advanced Excel Techniques

File Properties Tool

Table of Content

About the tool

File Properties Tool is an MS Excel based tool which helps you to get File Name, File Path, Date Created, Date Last Accessed, Date Last Modified, Size (MB) and File Type properties of the files. You just need to browse the folder where your files are and click on ‘Get File Properties’ button.

Tool Features

Get 7 properties of file

Excel VBA Master Tool Kit

File Name
File Path
Date Created
Date Last Accessed
Date Last Modified
Size (MB)
Type

Supports reading file properties from Sub-folders as well

Benefits

Save time to get file properties
Increase Accuracy

System Requirements

You need to have installed version of MS Excel 2010 or above

Tool Limitations

As the number of files increases, tool may take more time to get file properties

How to use this tool

Follow the below video which details out how to use this tool.

Open the tool and you will see below screen
If the macros are disabled, click on Enable Content button
Click on ‘Browse a Folder’ button and select the folder where your files are available
If you want to read the file details in the sub-folders as well then select the checkbox

Click on ‘Get File Properties’ button

Tool will now start reading file details. Once completed, you will receive a Done message

To clear the data, click on ‘Clear Data’

Recommended Articles

mail merge from excel to word

Advanced Excel Techniques

How to mail merge from Excel to Word

BySumit Shrimal

This step-by-step guide will show you how to easily do mail merge in Word using an Excel sheet.
Mail Merge can save you a lot of time when you need to send letters or emails to many people. It helps you create personalized letters, emails, or labels in Word by combining the information from your Excel sheet. This guide gives an overview of the main steps and explains how to do a mail merge from Excel in an easy way

Excel VBA Tool to Create Folders

Advanced Excel Techniques

Excel VBA Tool to Create Folders

Byexcelsirji

VBA Tools To Create Folders In VBA, you can use MkDir function to create folders in your system or shared drive. To make your work simple, we bring a free Excel VBA tool to create…

Time and Motion Tracker Header Image

Advanced Excel Techniques

Time Management Tools and Trackers

ByPradeep Kumar

Time Management is very effective way of managing the available time. Current competitive world is making the time management crucial. There are various ways, tools and techniques by which time management can be done easily.

Excel_Random

Advanced Excel Techniques | Excel VBA and Macros | Productivity and Automation

RANDOM Sampling Excel Tool

Byexcelsirji

Random Rows Selector is an MS Excel based tool which can be used to pick random or stratified samples from a set of records available in the Excel. The tool is fully dynamic, it can support any data format in Excel.

Employee Database Tool

Advanced Excel Techniques | Excel VBA and Macros | Productivity and Automation

Employee Database Tool

Byexcelsirji

Employee Database is an MS Access based tool to manage employee details. The tool supports upto 78 demographics for each employee such as Name, Location, Phone, Email, Address etc. The tool also comes with inbuilt attendance tracker to track daily attendance of employees. Over and above this, you can also design your own trackers and start using it.

Outlook-Email-Management-Tool

Advanced Excel Techniques | Excel VBA and Macros

Outlook Email Management Tool

Byexcelsirji

Outlook Email Management Tool is an Excel based tool which works with Outlook 2010 or above version and helps you to read, copy or move multiple emails from an Outlook folder and sub-folders on click of a button. The tool also supports extracting attachments from emails as well.

Leave a Reply Cancel reply

Excel VBA Master Tool Kit