Embedding Google Forms on WordPress

If you run a wordpress site and want to include simple poll questions or other specialized input forms on your pages or blog posts, consider the Google Forms plug-in from Mike Walsh. I’ve used it for years and it combines the power of Google Forms with WordPress. In your WordPress console, add & activate the […]

Continue reading

Excel Automation for Data Analysts

Should you learn VBA? Note: A very simple sample file and code can be downloaded just above the video. A lot of “real” programmers dismiss VBA and Visual-basic in general. This is short-sighted for a number of reasons. Building solutions should be about effective solutions, not a myopic focus on the “most powerful tool.” When […]

Continue reading

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