Advanced Excel Techniques Excel VBA and Macros

Dummy Data Generator Tool

Table of Content

About the tool

Dummy Data Generator is an MS Excel based tool which has capability of generating 45 types of data which includes numbers, text, date, time, Memo (long text), Booleans etc.

Tool Features

Generate unlimited dummy records on one click
Supports 45 types of data points
Capability to generate Numbers, Text, Date, Time, Long Text, Boolean and many more data types

Benefits

No additional software / investment required, works with commonly available Office Applications
Helps in tool testing
Helps in identifying bugs and deliver high quality tools

System Requirements

You need to have installed version of MS Excel 2010 or above

Tool Limitations

As the number of records increases, tool may take more time to generate random data

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
As the file contains macros, you may be asked to enable the macros to use the tool
Click on ‘Generate Dummy Data’ button
The form gets loaded with default fields. You may want to add more fields or delete unwanted fields
Following are the datatype which are available in the tool for selection

Once you are ready with the fields, click on ‘Generate Random Data’ button on the form

Within few seconds, tool will generate the data in a new workbook

Congratulations you are now ready to use the tool

Recommended Articles

Dummy Data Generator Tool

Advanced Excel Techniques

Dummy Data Generator Tool

Byexcelsirji

Table of Content How does testing help? How should I test my tool or application? How does Dummy Data Generator tool helps in testing? How do I use this tool? From many years I have…

Index match function

Excel Functions | 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.

VBA Code to Count Cells by Color

Advanced Excel Techniques | Excel VBA and Macros | Productivity and Automation

VBA Code to Count Cells by Color

Byexcelsirji

Have you ever felt that Microsoft should have added a formula in Excel which can count the cells based on specific color? I have seen many code requests to share a VBA code that can count the cells by its color. To help our subscribers and developers, we are sharing 2 codes that be used to count the cells with specific color and returns the count of the matching color cells.

File Properties Tool

Advanced Excel Techniques

File Properties Tool

Byexcelsirji

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.

VBA Code to Get User Name

Productivity and Automation | Excel VBA and Macros

VBA Code to Get User Name

Byexcelsirji

This Excel VBA Code helps to Get User Name. Here is an example environ(username) or Application.username.This macro gets the username from active directory.

VBA Code to Check if File Exist in Folder

Productivity and Automation | Excel VBA and Macros

VBA Code to Check if File Exist in Folder

Byexcelsirji

To ensure that your VBA project works smoothly without any error, you need to put lot of error handlers and validations. Here is one of them, below code can be used to check if the given path is valid or not. You just need to provide the path of the file to the function and it will check if the file exist at the location. If it returns True that means the file is available at the path, if it returns False that means it is invalid path or the file does not exist at the location.

Leave a Reply Cancel reply

Excel VBA Master Tool Kit