VBA Error Handling, Track Events & Custom Metrics within VBA Projects

Customer Success Stories

“…I needed to find a way to gain access to complete, accurate, and real-time data without burdening my clients and colleagues with additional responsibilities…” “…Using a free version I was able to confirm that it was a good solution for my requirements….”
“…also track how often certain parts of the Excel workbook were accessed, what tools and utilities were most popular, and objectively determine what aspects of our program were delivering the most value…” “… real-time notification and documenting of errors….”
“…this information was appended to the data being sent to Azure Insights…”

Dave Sheppard, Azura Consulting

Dave Sheppard

Dave is the founder and principal consultant at Azura Consulting. He’s a senior procurement consultant with a specialization in advanced data analytics.

Read The FULL Story

Azure Application Insights for VBA – Features

Track Page View

Use this to track Userforms or Worksheets your users are opening.

Example:

clsAI1.TrackPageView "Worksheet1 Open"

Track Events

TrackEvents function sends your custom data about the events you want to track from within Excel Workbook VBA to Microsoft Azure – Application Insights.

Example:

clsAI1.TrackEvent "CommandButton1_Click"

Track Errors

Use TrackException function to send tracking data about your errors from, for example, your Excel Workbook within VBA to Microsoft Azure – Application Insights.

Example:

clsAI1.TrackException Err.Description, Err.Number, Erl, "Workbook_Open"

Track Metric

Use this to track duration of your code blocks, send performance measurements such as execution lengths or to pass some metrics with the name and value to Microsoft Azure – Application Insights.

Example:

clsAI1.TrackMetric "My Metric Name", 123

Asynchronous Logging

The impact on your app’s performance is almost none. Tracking calls are non-blocking, and are batched and sent in a separate thread.

This is why we say “in almost real-time”.

Connect VBA to Microsoft Azure

Nothing to install!

Import 1 VBA class module to your VBA project (Excel, Access, Word, Powerpoint, or other apps that support VBA) and send events from your VBA project to Microsoft Azure – Application Insights with only 3 lines of VBA code.