File Properties Tool

File Properties Tool
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
File Properties Tool

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
    File Properties Tool
  • If the macros are disabled, click on Enable Content button
    File Properties Tool
  • Click on ‘Browse a Folder’ button and select the folder where your files are available
    File Properties Tool
    File Properties Tool
  • If you want to read the file details in the sub-folders as well then select the checkbox
File Properties Tool
File Properties Tool
  • Click on ‘Get File Properties’ button
File Properties Tool
  • Tool will now start reading file details. Once completed, you will receive a Done message
File Properties Tool
  • To clear the data, click on ‘Clear Data’
File Properties Tool

Recommended Articles

File Properties Tool

Similar Posts

Time-and-Motion-Professional-Tracker

Time and Motion Professional Tracker

Byexcelsirji

Time and 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+W) or Stop (Ctrl+E) buttons to record the time stamp. This is professional version of our famous Time & Motion Tracker. This version includes features such as Hold Timer, Consolidation, Utilization Analysis, Dashboards etc.

mail merge from excel to word

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

advanced filter

Advance Filter in Excel – how to create and use

BySumit Shrimal

This guide explains the basics of Excel’s Advanced Filter and shows you how to use it to find records that match one or more complicated conditions.
If you’ve read our previous guide, you know that Excel’s regular filter offers different options for filtering text, numbers, and dates. These options work well for many situations, but not all. When the regular filter isn’t enough, you can use the Advanced Filter to set up custom criteria that fit your exact needs.
Excel’s Advanced Filter is especially useful for finding data based on two or more complex conditions. For example, you can use it to find matches and differences between two columns, filter rows that match another list, or find exact matches with the same uppercase and lowercase letters.
Advanced Filter is available in all Excel versions from 365 to 2003. Click the links below to learn more.

Leave a Reply

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

Excel VBA Master Tool Kit