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

How to Create a Default Website Image for Facebook Sharing Using Google Drawings

Whew!!! Long title. I published a simple tutorial on how to create the image below with the text overlay and semi-transparent background. Google Drawings is a FREE app that comes as part of your Gmail address or with your GSuite subscription. Benefits FREE! Cloud-based: any computer, any location, no software to install Allows collaboration: Team […]

Continue reading

New Prospecting and Sales Call Software – Hyper Call Q

Los Angeles, CA – Pulse Infomatics Streamlines the Sales Call and Prospecting Process Pulse Infomatics is preparing to release it’s flagship Sales Prospecting and Call Center software, Hyper Call Q, for limited custom release in January 2017. Hyper Call Q provides a simplified, single-screen and push-button actions, for almost all call resolutions. Additionally, sales reps […]

Continue reading

Embedding Google Forms on WordPress

If you run a wordpress site and want to include simple poll questions or other specialized input forms on your pages or blog posts, consider the Google Forms plug-in from Mike Walsh. I’ve used it for years and it combines the power of Google Forms with WordPress. In your WordPress console, add & activate the […]

Continue reading

Excel Automation for Data Analysts

Should you learn VBA? Note: A very simple sample file and code can be downloaded just above the video. A lot of “real” programmers dismiss VBA and Visual-basic in general. This is short-sighted for a number of reasons. Building solutions should be about effective solutions, not a myopic focus on the “most powerful tool.” When […]

Continue reading

How to migrate SQL Server instances with permissions to a new server

We recently virtualized a client’s server environment. We’ll write more about virtualization, general concepts, at a later date. As part of that, we had to migrate 3 SQL Server instances to a new server. This was made significantly simpler with a Powershell Script. DBATools – Powershell Scripts to Migrate SQL Instances Download and install the […]

Continue reading