You can follow the instructions in video format, or scroll down to follow the instructions in a detailed step-by-step text article.
Video: How to Create a Free Microsoft Azure Account – Azure Application Insights for VBA – Step 01
Video: How to create a new Azure Application Insights resource – Application Insights for VBA – Step 02
To track usage & performance of your VBA projects (Excel, Access, Word, Powerpoint,…) we will use the Application Insights resource that you can get with the FREE Microsoft Azure account.
- If you don’t have a Microsoft Azure account go to azure.microsoft.com and create a new free account.
- Now that you have your Azure account, log in to your portal.azure.com account.
- In the search bar type: Application Insights
- Click on Application Insights
- Click on +Add
- Create a new Resource group, for example: “MyResource”
- Give a unique Name for your Application Insights resource, for example: “My_Excel_Workbook”
- Choose a Region that is close to you and your users, for example, I’m in Europe so I will choose “(Europe) West Europe”
- We don’t need Tags, so we can click on “Review + create”
- If everything is ok, we should get the “Validation passed” message. Then click on “Create”
- After a few moments, your Application Insights resource should be created.
- Now type again in the search bar “Application Insights” and when you click on the “Application Insights” you should see your resource, with your name, created. Click on it.
- On the Overview tab, in the right top corner, there should be a label called “Instrumentation Key”
- Copy this “Instrumentation Key”, because we will need it in our VBA code to tell the VBA class where to send our telemetry data.