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

VBA to Extract All Excel Formulas in a Workbook

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

Continue reading

Sharing Microsoft Excel Data Using SQL Server or Microsoft Access

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

Continue reading

Listing Excel Workbooks and Sheets from Microsoft Access using VBA

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

Continue reading

Business Automation

Workflow automation solutions. Document assembly (contracts, reports, proposal systems, letters, emails) – all driven by your data. We’ve built solutions for insurance, legal, manufacturing, and entertainment.

Continue reading

Data Analytics and Digital Dashboards

Your data means something. We help it speak to you. Better business intelligence, decision support, exception reporting, and visibility to the challenges, and more importantly, the opportunities your data is telling you about.

Continue reading