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),
Read more
Product
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
Read more
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
Read more
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
Read more