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
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
Read more
Where is Microsoft Excel VBA or Excel IDE
Microsoft Excel VBA comes with every installation of Mircosoft Office. In this short section, I will show how to launch
Read more