Latest Posts

Convert Excel data to JSON CSV and XML format

Convert Excel data to JSON CSV and XML format

By default, Excel doesn’t provide any formula to convert a range or a table into a JSON (JavaScript Object Notation),

Convert Excel data to JSON format using VBA

Convert Excel data to JSON format using VBA

JSON format data is widely popular when it comes to send and receive information between a web server and a

Use Statusbar as Progressbar in Excel VBA

Use Statusbar as Progressbar in Excel VBA

There is not an easy way to use existing progress bar neither there is any class to use to show

Create Dictionary and KeyValuePair Classes in Excel VBA

Create Dictionary and KeyValuePair Classes in Excel VBA

Unlike in .NET framework, Microsoft Excel VBA doesn’t provide a Dictionary class. Here I have created a Dictionary class, rather