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 readingAuthor Archive: Matthew Moran
Quickbooks SDK iAddCheck using VBA. Add a check from Excel or Access
Someone reading my part 1 of ??? tutorial on Quickbooks – sorry.. read the notes. đ Â – was struggling to find how to add checks. I wrote them this morning about what to look for in the On Screen Reference OSR for the Quickbooks SDK. iCheckAdd Under the Onscreen Reference, there is a iCheckAdd message. […]
Continue readingCampus Mesh WiFi using Sonicwall, Ubiquiti, and Open-Mesh (network integration)
Overview Our client, an RV resort, needs a robust and scaleable WiFi network for guests. Technologies/Vendors SONICWALL Open Mesh Ubiquiti The Challenge A family of four can easily be responsible for 7 to 10 WiFi connections: 1 smart TV 2 laptops 1 tablet 4 smart phones 8 connections These connections are likely streaming Netflix, […]
Continue readingGet 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 readingRetrieve 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 readingAffordable Care Act Form 1095 Reporting
A project outline. Creating ACA form 1095 data using SQL Server, Excel, and VBA automation.
Continue readingProgramatically 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 readingFounder’s blog – why we stopped selling social media
Pulse Founder, Matthew Moran, explains on his blog why we stopped selling social media to focus on database development and high-value information technology services. He also provides some advice on how you can fix your social media.
Continue readingConnecting Microsoft Access and Quickbooks using the Quickbooks SDK part 1 of 3
Aging Post Note: I considered taking this down. At this point, I’m not writing the series. I am busy with a myriad of projects – both programming and in other areas (see my music/writing blog). However, I will publish some VBA SDK code as more or less stand-alone blog entries. I’ll categorize them under the […]
Continue readingGoogle 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 readingMailmerge 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 readingCustom Reports using Excel and SQL Server from Time Plus payroll software
Technology SQL Server Microsoft Excel Time Plus Payroll Software The Challenge One of our clients needed a custom 401k report. They were manually creating the report using data in canned/available reports. We wrote a custom script to extract the data, pull it into Excel in the format required, and save the file with […]
Continue readingVideo: 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 reading3 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 readingLearn 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 readingTeam 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