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

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.

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.

Streamlining Work Allocation with an Outlook-Based Excel Tool

Advanced Excel Techniques

Streamlining Work Allocation with an Outlook-Based Excel Tool

Byexcelsirji

Table of Content Introduction Benefits of Using Outlook and Excel for Work Allocation Setting Up Your Outlook-Based Excel Tool Managing Work Allocation Conclusion Download Free Excel Template Introduction Efficient work allocation is crucial for organizations…

Duplicate Data Identifier

Advanced Excel Techniques

Duplicate Data Identifier Tool

Byexcelsirji

Duplicate Data Identifier is an MS Access based tool which helps to identify duplicates from any Excel based data. The tool supports up to 10 conditions and 25 types of matching conditions to find the exact duplicate. You can also define formatting conditions to first format the data before checking for duplicates.

index match function

Advanced Excel Techniques

Index Match in Excel

BySumit Shrimal

Index Match in Excel are powerful tools for advanced lookups. They’re popular because they’re incredibly flexible. You can use them to search horizontally or vertically, perform two-way searches, find values to the left of your search criteria, handle case-sensitive searches, and even search using multiple conditions. If you want to improve your Excel skills, mastering INDEX and MATCH is essential. Below, you’ll find numerous examples to help you grasp how they function.

Time-and-Motion-Professional-Tracker

Advanced Excel Techniques

Time and Motion Tracker

Byexcelsirji

Time & Motion Tracker is an MS Excel based tool which helps you to track Start and End time of any type of transaction or activity. The tool is developed using VBA coding which helps you to protect manual manipulation in the data by the user. It is also easy to use, just click on Start (shortcut: Ctrl+Shift+A) or Stop (Ctrl+Shft+S) buttons to record the time stamp.

Leave a Reply Cancel reply

Excel VBA Master Tool Kit