Updated: Microsoft Excel VBA and Google Maps to calculate distances and time from multiple locations

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 […]

Continue reading

Google Apps Workshop Slides and Video

Last week, Matthew Moran, gave a workshop as part of The Russell Fisher Business Collection at the Camarillo Library. The RF Business Collection is a grant that provides the library funds for hosting business workshops and informational seminars. Georg Winkler administers and books speakers for the event. He has also started getting them on video […]

Continue reading

Microsoft Access and Word VBA Document Assembly System Demo

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 […]

Continue reading