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!!!  😉 Recently, a client wanted a market analysis showing how far customers traveled … Continued

Retrieve Data from Website in Microsoft Access or Excel using VBA

File Download: Microsoft Access/VBA Sample File 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 … Continued

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

Aging Post Note: See Edit below 1/9 I’ve received some well-deserved snarky comments due to my failure to post parts 2 & 3. Okay okay okay! I have heard you loud and clear! Some of you were really funny too. … Continued

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 … Continued

What grocery shopping can teach us about business-aligned IT

posted in: Consulting | 0

I sat across from the controller.. my first meeting with someone who would become a friend and advocate. She placed three proposals in front of me. “I have these proposals.. all for system-wide upgrades. They range in price from $140,000 to … Continued

1 2 3 4