Summary An explanation of how to retrieve/scrape website data using MSXML and HTMLDocument but not using the InternetExplorer Application Object. The problem with the InternetExplorer.Application object I have a few blog entries demonstrating how to get web site data using InternetExplorer and the HTMLDocument object. However, there are a few problems with this: Microsoft is […]
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. […]
Overview Our client, an RV resort, needs a robust and scaleable WiFi network for guests. Technologies/Vendors SONICWALL Open Mesh Ubiquiti The Challenge A family of four can easily be responsible for 7 to 10 WiFi connections: 1 smart TV 2 laptops 1 tablet 4 smart phones 8 connections These connections are likely streaming Netflix, […]
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 […]
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 […]
A project outline. Creating ACA form 1095 data using SQL Server, Excel, and VBA automation.
Summary: Our client wanted to extract data from a web portal. We wrote a VBA script to the requested information and store it in an Access database. The example below demonstrates the same technology, but the data is stored in Excel. Edit: 7/23/2017 – An improvement on this solution. Edit: 9/9/2016 – I posted a download […]
Pulse Founder, Matthew Moran, explains on his blog why we stopped selling social media to focus on database development and high-value information technology services. He also provides some advice on how you can fix your social media.
Aging Post Note: I considered taking this down. At this point, I’m not writing the series. I am busy with a myriad of projects – both programming and in other areas (see my music/writing blog). However, I will publish some VBA SDK code as more or less stand-alone blog entries. I’ll categorize them under the […]