Retrieve Data from Website in Microsoft Access or Excel using VBA

File Download: Microsoft Access/VBA Sample File Edit: 7/23/2017 – an improvement to this solution. This will require some refactoring. 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 download. The […]

Continue reading

Programatically retrieving data from a website into a database

Summary: Our client wanted to extract data from a web portal. We wrote a VBA script to the requested information and store it in an Access database. The example below demonstrates the same technology, but the data is stored in Excel. Edit: 7/23/2017 – An improvement on this solution. Edit: 9/9/2016 – I posted a download […]

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

What grocery shopping can teach us about business-aligned IT

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 $235,000. How do I know which one is right?” I glanced briefly at the proposals […]

Continue reading