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

Video: Is LinkedIn an Effective Social Network

In this short (2:55) video clip, Pulse founder, Matt Moran, answers a question about LinkedIn as a social platform and provides some insight on how to use that network, and others, for true engagement. Also, a little about the “Like my page and I’ll like yours” phenomenon. Using LinkedIn More Effectively Some tips and the clip […]

Continue reading

3 Ways to Make Your Company Network Faster TODAY!

The Real Problem: Part 1 – Getting Back to Basics So many clients believe that they need to upgrade all kinds of equipment, including every desktop computer, in order to regain the speed they remember enjoying earlier on.  All in the name of “Investing in Communications” or “Improving our Business Infrastructure.”  The truth is hardware […]

Continue reading

Learn how to delegate tasks

The most important facet of project management is NOT tracking tasks. It is the effective delegation of those tasks. Pulse founder, Matthew Moran, provides executive coaching as part of our service offering. A few weeks ago he worked with a select group of 6 executives on team collaboration strategies and tools. Now he is introducing an […]

Continue reading

Team Collaboration and the Inefficiency of Email

At Pulse, we’ve adopted Glip.com as our internal project communication tool… and it is AMAZING!!!  “a single email about a project can result in dozens of responses.. email clutter” Have you seen/experienced this at your organization? Someone sends an email to several (let’s say 5) recipients asking for feedback on some tasks or document. 4 […]

Continue reading