Category Archives: OneNote

Part 2c: Using VBA with JSON: OneNote

Today, we’ll cover OneNote in our series on using VBA and JSON. You can download the database sample I’ve provided and skip to “Explanation of Code” or you can create the modules manually. Today’s Lesson on GitHub Link to get token OneNote API documentation database sampleFinal Code Or skip down to explanations of how to […]

Part 2b: Using VBA with JSON: Wunderlist

This Lesson’s Code on Github Sample DatabaseOr skip down to explanations of how to do various things in Wunderlist: Get a List of Wunderlist Lists Get a List of Wunderlist Folders Get List of Tasks on Wunderlist List Add a task to a Wunderlist List Some of this content will be repeated from the previous […]

Part 2a: Using VBA with JSON: Courtlistener

This Lesson’s Code on Github Today, we’re going to go over how to use VBA to interact with JSON around the web, so you’ll need one piece of software for now, Microsoft Office. When we get to PDFs later, you will need Acrobat (not Reader, but Acrobat). We’ll learn how to get information off the […]

Part 1e: Organizing Workflow, Code, and Document Production

Here, I am going to share some thoughts on how I made my workflow and database so, as we’re going through how to do all this cool stuff, you yourself can think about what you need and how to frame it so that you end up with a complete solution. I am not an expert […]

Part 1d: If-Then-Else Statements

Get this lesson’s code on my GitHub. An if-then-else statement is pretty much exactly how it sounds: if X happens, then do something; else do something else; followed by “end if”. You can also do things like toggle boolean variables/properties: And here is a shorter one-line version of the above, and you can use this […]

Part 1c: DAO Recordsets

What’s a DAO recordset? It’s a ‘set’ of records you define the way you want in Access. You use recordsets to pull information from what might be a ginormous amount of information in a database, so that you are working with a smaller set of data at one time. You don’t want to put anything […]

Part 1b: Operators/Math

This one’s pretty easy or self-explanatory, but it still deserved its own section. You can do a lot of cool things with strings if you understand the different operators and how you can use them in combination with if-then-else statements and comparing strings. It is a good idea to keep short lines when you code. […]