Excel

Integrations

Can embed excel workbooks like: (how to)

Can add to Coda if uploaded to OneDrive

Parts

Sparklines

right click cell(s) to access
Example:

VBA

Basics

Continue code on next line (source)

this is some code _
use the underline to continue it

custom functions must be in a module

API Requests

Official documentation for xmlhttpRequest

"o use early-binding add reference to these libraries: Microsoft XML and Microsoft WinHTTP services:"
source

Examples/Tutorials:

• make http requests in excel vba by codingislove.com
  • how to build a simple weather app
• https://github.com/armineminasyan/vba-gmaps-directions

Resources

Guide - W3 Schools

Manually add a google geocoding custom function via vba

• full VBA code - very nice layout

https://www.reddit.com/r/vba/comments/rauslf/api_call_in_vba/

https://vbaplanet.com/libmsxml2.php

• https://vbaplanet.com/http.php