Tutorial
JSON to Excel: Import and Export with VBA (2026)
Convert JSON to Excel with VBA-JSON: copy-paste macros to import a JSON API or file into a sheet, and export Excel rows back to JSON.
Tag
Excel
8 posts
TutorialHTTP Requests in Excel VBA: GET and POST Examples (2026)
Make HTTP GET and POST requests in Excel VBA with XMLHttpRequest or WinHTTP: copy-paste macros with JSON headers, error handling and basic auth.
TutorialParse HTML in Excel VBA - Learn by parsing hacker news home page (Updated 2022)
A detailed tutorial on how to parse HTML in VBA using Microsoft HTML object library. This includes practical example where we parse Hacker News homepage.
TutorialApps script to delete resolved comments in google sheets? | Answering viewers questions
This is a new series called "Answering viewers coding questions". Someone has requested me for an answer on Quora - "What is an apps script to delete…
TutorialConvert Json to csv and csv to Json in Excel VBA
A step by step tutorial explaining how to read a file, write a file, convert JSON to CSV and CSV to JSON programmatically using Excel VBA.
TutorialHow to build a simple weather app in Excel VBA
One of our readers posted a question on the forum asking how to get weather data using VBA. So I created a very simple weather app in Excel VBA.
TutorialWeb Scraping with VBA: Selenium Example (2026)
Web scraping with VBA in Excel: scrape a website with Selenium, see when XMLHttpRequest or a JSON API is faster, with copy-paste macros.
TutorialBrowser automation in Excel VBA using Selenium
A simple tutorial on how to automate browser based tasks in VBA using selenium VBA which is a .NET wrapper for selenium framework.