From many years I have been working on VBA based automation projects using Excel, Outlook, Word, Access and other technologies. As a professional developer it was my responsibility to test the tools with all possible scenarios and data. Proper testing of the tools helps to deliver bug free and quality tools to clients.
If you are also a programmer and developing a tool or application. You should always test your tool with all possible scenarios that may come in production environment.
Step 1: Download and save the following attachment in you system
Step 2: Unzip the file and open
Step 3: As the file contains macros, you may be asked to enable the macros to use the tool
Step 4: Click on ‘Generate Dummy Data’ button
Step 5: The form gets loaded with default fields. You may want to add more fields or delete unwanted fields
Step 6: Once you are ready with the fields, click on ‘Generate Random Data’ button on the form
Step 7: Within few seconds, tool will generate the data in a new workbook
Step 8: Congratulations you are now ready to use the tool
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 Excel.
File Manager tool is an Excel based tool which helps you to delete or move unwanted files from your system. It requires a source and destination folder (in case you want to move files). First it lists all the files available in the folder or sub-folders then you can select the action to be taken for each file such as Move or Delete. With a click of button, tool will take all necessary actions.
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.
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
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.
VBA Code to list Files in Folder To work on multiple files through VBA programming, you need to have VBA code that can list files in a folder. Here is a simple code for you,…