This is the second part of our two-part series on using VBA with JSON in OneNote. Today, we’ll learn how to delete pages, update them, copy to a section, and create sections and section groups. Using VBA with JSON: OneNote, Part 1 on GitHub Using VBA with JSON: OneNote, Part 1 Today’s Lesson on GitHub […]
Author Archives: Erica L. Ingram
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 1f: Loops
Get this lesson’s code on my GitHub. Today, we’re going to learn about loops. You’ve already been exposed to them a little in the previous article or two and here we’re going to go over each one in some detail. A loop is a piece of code that tells the computer to repeat an action […]
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 […]
Code Formatting Tips
This post is ongoing and I will add to it as we progress. Info Boxes Note I have put what I call a comment block here. Now, if you just use one-off functions and have just a couple functions sitting around that you use, you may not think this is necessary. However, if you are […]
CourtListener, JSON, VBA, and Word
UPDATE: Here’s the post on how to use VBA with JSON using CourtListener as an example, or you may view the Wunderlist how-to here. So before I talk about recordsets, I want to say I’ve spent some time recently learning how to parse/process JSON from CourtListener in VBA, which enables a person to obtain search […]
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 […]