Microsoft Access and Excel programming in Los Angeles

Quickbooks SDK iAddCheck using VBA. Add a check from Excel or Access

Someone reading my part 1 of ??? tutorial on Quickbooks – sorry.. read the notes. 😉  – was struggling to find how to add checks. I wrote them this morning about what to look for in the On Screen Reference OSR for the Quickbooks SDK. iCheckAdd Under the Onscreen Reference, there is a iCheckAdd message. […]

Get Multiple Distances Using the Google Maps API and VBA for Excel or Access includes sample file

Automate Everything I hate manual processes. NOTE: If I get one more email from someone nagging me to finish that Quickbooks SDK Tutorial.. I’m going do it!!!  😉 Edit: 7/26/2017 – Okay.. I lied. I cannot get to it per se… but I am posting some code to help with QuickBooks integration from time to […]

Retrieve Data from Website in Microsoft Access or Excel using VBA

File Download: Microsoft Access/VBA Sample File Edit: 7/23/2017 – an improvement to this solution. This will require some refactoring. A week or so ago a reader asked (on this blog post), if we could place the file online that performs the operation in this blog post (and video). I’ve included it below as a download. The […]