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
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…
How to Find Duplicate Files In excel using VBA? 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…
Excel Files and Sheets Consolidator is an MS Excel based data consolidation tool which can be used to consolidate data from multiple Excel Files or Excel Sheets. The tool supports multiple configurations such as Sheet Name, Sheet Index, Header Row and Non-Blank column to help consolidating accurate data.
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.
Free File Renamer Tool – Quickly Rename files batch using Excel VBA Here is another help code and tool for programmers to rename files. You can use this tool for renaming all files available in…
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.