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 […]
Category Archives: Publisher
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 […]
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. […]
Part 1a: Variables
Get this lesson’s code from my GitHub. This is post number one. In the event I forget something, my plan is to teach it when it comes up, then come back and add it to the appropriate more in-depth post. I am going to take a lot of parts of what I’ve learned from writing […]