FREE VBA UTILITIES
33

VBA Tool to Track Start and End Time (Time & Motion Tracker)

Here is one more wonderful free tool from ExcelSirJi.com which makes your life easy. Time & Motion Tracker helps you to track Start and End time of any type of transaction or activity. The good thing is, it is VBA based tool which helps you to protect from 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

Read More
VBA Code to Find Duplicate Files
FREE VBA UTILITIES

VBA Code to Find Duplicate Files

Yesterday I was working on my computer and cleaning the drives to make some more space.  I was surprised to see so many files saved at multiple places which was consuming huge space of my computer drives. One of the biggest tasks was to identify such duplicate files. Initially I …

Read More
VBA To Rename Files
FREE VBA UTILITIES
2

Excel VBA Tool to Rename Files

Here is another help code and tool for programmers to rename files. You can use this tool for renaming all files available in a selected folder. Just browse the folder and hit ‘Rename Files’ button ‘This function loops through all the files listed in the sheet and ‘rename them as …

Read More
FREE VBA UTILITIES

VBA Tool to Merge Excel Files from a Folder

From last few months, we have been receiving frequent requests from users for a VBA tool which can consolidate Excel files from a folder. So here we come with one more free VBA tool from ExcelSirJi team. With this Excel Consolidator tool, you will be able to consolidate data from …

Read More
FREE VBA UTILITIES
3

Excel VBA Tool to Get File Properties

Here is one more interesting VBA tool from ExcelSirJi team. File Properties Tool is an Excel VBA tool which gets the following properties of the file. File Name Date Created Date Last Accessed Date Last Modified Size (MB) Type  You just need to browse the folder where your files are …

Read More
FREE VBA UTILITIES
3

Excel VBA Tool 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 folders. To use this tool, enter Base folder path where you want to create folders and the name of the …

Read More
FREE VBA UTILITIES

Custom Calendar Control for MS Access

MS Access by default provides inbuilt functionality to pick dates using calendar control; however it lacks few basic functionalities which makes selecting a date bit difficult. For example, if you want to select a date from year 2015 then you need to navigate multiple times to select correct date since …

Read More

error

Like the Article? Please spread the word :)

Facebook
Facebook
YouTube
YouTube
Pinterest
Pinterest
LinkedIn