This repository contains ready-to-use Excel files demonstrating how to call public Web APIs directly from VBA.
Each .xlsm file is fully functional — just download, enable macros, and explore.
| Topic | Description | Excel File |
|---|---|---|
| Quantum Random Numbers | Fetch true random numbers from ANU’s Quantum RNG API | Download XLSM |
| Location and Weather Data | Fetch loacation and weather data from api.open-meteo.com | Download XLSM |
Follow the ongoing LinkedIn series:
Excel + Web APIs – by Dirk Nötzel