Is your SAGE 50 Accounting too slow? Virtualization and Terminal Server

Technologies Sage 50 Accounting 2017 & 2018 Windows 2016 Hyper-V Windows 2016 Remote Desktop Server (Terminal Server) Dell Poweredge T330 Server Sage 50 Performance Sage has performance issues going back to its Peachtree roots. It is inefficient on a network and has poor utilities for purging and compressing data. My client was at their wits […]

Continue reading

VBA solution: Scraping website information using MSXML, HTMLDocument, and getElementsByClassName

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

Continue reading

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

UPDATE 5/1/2019 I’ve updated this tool. To download the updated sheet visit this new blog entry. Or click the image below. … Recently, a client wanted a market analysis showing how far customers traveled to get to their location. They were having employees manually check addresses using Google maps to determine this information and entering […]

Continue reading

Google adds voice to text to Google Docs

Google Drive/Docs = Amazing! First, let me say it again. If you are NOT using Google Drive/Google Docs, you need to start immediately! A few weeks ago I demonstrated how you can use your Android voice-to-text to dictate into a Google Document. That’s great technology for note-taking and even longer documents. Now Google has introduced […]

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