Convert Json to csv and csv to Json in Excel VBA
I recently received a query on how to convert JSON to CSV. Usually, If the JSON file is small or has a simple structure then…
Tag: Excel
How to build a simple weather app in Excel VBA
One of our readers posted a question on forum asking how to get weather data using VBA. So I created a very simple weather app…
Parse HTML in Excel VBA – Learn by parsing hacker news home page
Why parse HTML in Excel VBA? There may be different cases where we need to parse HTML in Excel. Few cases are generating multiple HTML…
Import Json to excel and export excel to Json
JSON (Javascript Object Notation) is the most used data exchange format nowadays. Microsoft Excel doesn’t have built-in support for importing JSON to excel or exporting…
XmlHttpRequest – Http requests in Excel VBA
Excel is a powerful and most popular tool for data analysis! HTTP requests in VBA gives additional capabilities to Excel. XmlHttpRequest object is used to…
Scrape website using Selenium VBA
This post is continuation to Browser automation in Excel using Selenium VBA. Have a look at that post first as it explains how to get…
Browser automation in Excel VBA using Selenium
When it comes to browser automation tasks in Excel VBA like filling a web form, login to a website etc. most of them use Internet…