Campus Mesh WiFi using Sonicwall, Ubiquiti, and Open-Mesh (network integration)

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, […]

Continue reading
Google Maps and Excel VBA

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 […]

Continue reading

Connecting Microsoft Access and Quickbooks using the Quickbooks SDK part 1 of 3

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 […]

Continue reading

Mailmerge without using Microsoft Outlook uses only Excel, VBA, Word, and CDOSys

Summary: Send personalized emails to a list of email addresses and names in Microsoft Excel. Technologies used Microsoft Excel Microsoft Word VBA (Visual-basic for Applications) CDOsys (Collaboration Data Objects for Windows 2000) CDOSys Documentation It’s amazing how poorly documented it is.. but this link has some answers. https://msdn.microsoft.com/en-us/library/ms526318(v=exchg.10).aspx And Dan at Microsoft has several links: […]

Continue reading