Skip to content

PULSE INFOMATICS

Business Automation, Workflow, & Analytics Consulting

  • HOME
  • SERVICES
  • CONTACT
  • ARTICLES
  • Menu

Tag Archives: DOM

Programatically retrieving data from a website into a database

Posted on September 14, 2015July 23, 2017 by Matthew Moran

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→
Learn how to automate using Visual-basic for Applications

Recent Posts

  • Using Google App Scripts for contract assembly and save as PDF documents
  • How to use Google App Scripts to send HTML emails from Google Sheets with Airtable Data
  • Airtable Reporting Dashboard using Google Apps Script, Google Big Query and Google Data Studio
  • Airtable Database Systems: The Good, The Bad, and the Ugly (really ugly)
  • Excel VBA Google Distance Matrix API and Google Static Map Image API
  • Solving line breaks and other unstructured data when importing CSV files
  • How I check if optional parameters were passed to a c# method
  • Updated: Microsoft Excel VBA and Google Maps to calculate distances and time from multiple locations

Categories

Pulse Infomatics: Software Development, Office Automation, Technology Consulting