This is a demo of a recent client project. Based on my Google Distance Calculator example (go here to view and download). Below is a video demo and downloadable example of the project. Technologies Used: Excel VBA, Google Maps Distance Matrix API, Google Maps Static Map API. My client needed a list of addresses to […]
I’m going to provide a sample text file and a sample Excel VBA macro file for you to test. You can find the download below. Structured Data is Nice but Not Always Possible It would nice if every system had the ability to export data in more structured formats, like XML or json, rather than […]
Excel File download with VBA and Google Maps to calculate distance and duration between multiple destination addresses. Updated 5/23/2019: Fixed error where re-encoded origin string resulted in incorrect distances after 10 destination addresses. I’ve been asked to update this and address a few things in the code for a couple years. Back on October of […]
We just published the initial version (beta: ver. 0.5) of an MPAA Content Security Audit Review Tool built in Microsoft Excel. The Motion Picture Association of America (MPAA) has a Content Security Best Practices Common Guidelines document that our client needed us to follow to help them pass a digital security audit review. The audit […]
Summary: This demonstrates a methodology and some of the associated technologies I’ve used to create complex and flexible contract generators, proposal generators, and other document assembly systems. Technologies: Microsoft Access (SQL Server*) Microsoft Word – Word Templates – Word Global Template w/AutoText Entries * SQL Server: For simplicity, this demonstration uses Microsoft Access as the […]
Summary In our own work with data analytics, in coaching financial & business analysts, and with data conversions, we often coach clients to learn and use Microsoft Access or SQL Server, rather than (or perhaps more accurately, in conjunction with) Microsoft Excel. In this article, we explore some of the reasons why. “I suppose it […]
Summary Some visual-basic for applications code to extract all the formulas from every sheet in an Excel Workbook and save them in a text file. Background Avoiding a long explanation, we’ve been writing a reporting tool that combines a Microsoft Access front-end to a SQL Server database. It generates and updates some Excel reports/data visualizations […]
Summary Demonstrate how data can be cleaned up and shared across multiple users while allowing reports and visualization in well-known and common tools. Technologies Microsoft SQL Server (Express) Microsoft Access & The Access Runtime Microsoft Excel Add-on: Microsoft Power BI The need Provide a data aggregation and cleanup tool with customized and shared Excel reports. […]
SUMMARY: Tutorial to show how to use Microsoft Access VBA to retrieve and display open Workbooks and their Worksheets. I create a lot of dashboards, reporting systems, and document automation projects built extensively using Visual-Basic for Applications. Often, the infrastructure looks like: Microsoft Access as a front-end application. SQL Server as the back-end data repository. […]