Access & Excel VBA Application Usage & Performance Monitoring Online with Azure Application Insights | Davor Geci | Skillshare

Playback Speed


  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Access & Excel VBA Application Usage & Performance Monitoring Online with Azure Application Insights

teacher avatar Davor Geci, [email protected], Programmer | Excel VBA

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

12 Lessons (33m)
    • 1. VBA Application & Usage Monitoring Online with Azure cloud - Introduction

      1:48
    • 2. How to create a FREE Microsoft Azure Account

      12:25
    • 3. Creating new Azure Application Insights resource

      1:30
    • 4. Overview of blank Azure Application Insights resource

      0:23
    • 5. Resources & where to download them online (VBA Telemetry client & Excel Samples)

      1:01
    • 6. Installing VBA Telemetry Client

      0:46
    • 7. Connecting your VBA Application to Azure Application Insights resource

      2:21
    • 8. Sending Events to Azure Application Insights resource

      2:54
    • 9. Sending Custom Event from VBA to Azure

      1:58
    • 10. Quick Overview of Data sent to Azure Application Insights resource

      1:22
    • 11. Quick view of Advanced Analytics for Application Insights

      0:34
    • 12. Tracking VBA Errors with Azure Application Insights

      5:31
  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

66

Students

--

Projects

About This Class

How to in real-time & online track Events, Metrics, Errors & usage of your VBA projects-Access, Excel, Word, PowerPoint

Excel VBA & Access VBA Application Usage & Performance Monitoring Online with Azure Application Insights.

In this class, you will learn how to connect your Excel VBA Workbook, Access VBA Application or any other Microsoft Office product that supports VBA and Microsoft Azure cloud.

Why? Because ...

... You created a killing Microsoft Office document, Access VBA Application, Excel VBA Workbook, Word document or PowerPoint slideshow or other that supports VBA (Visual Basic for Applications). 
 
You've distributed them around the world to your users. 
 
But how do you know if there are any bugs in your, eg. Excel VBA code,  what parts of your document is used the most, which function, routine or part of the Access VBA or Excel VBA code is executed faster or slower on your user's machines? 
 
Or are your Microsoft Office documents used at all? 
 
Now you can! With help of VBA Telemetry and  Azure Application Insights. 

All you need is a Free Azure Account and a Free version of VBA Telemetry client. 
 
Insert few lines of VBA code into your Office document (eg. Excel VBA code) and enjoy how your tracking data is flowing into your FREE Azure Account ready to be viewed and analyzed by you.

----------------------------------------------------

From the author of the VBA Telemetry client, Davor Geci, with more than 20 years of programming experience, you will learn how to, with just a few lines of VBA code, connect your Access VBA or Excel VBA or Word or PowerPoint or any other VBA project with Azure Application Insights (Microsoft Azure cloud).


This will give you the unseen opportunities and possibilities for improving and monitoring your VBA projects (eg. Excel VBA projects), no matter where the user is located.  
And all that in real-time.


So don't wait.  
Take this class NOW!

Meet Your Teacher

Teacher Profile Image

Davor Geci

[email protected], Programmer | Excel VBA

Teacher

Davor is a veteran programmer with 20 years of being a professional programmer and 15 years of building companies as CEO or helping others as an HR consultant in employee recruitment.

Specialties: VB, VBA, Error Handling, Azure Application Insights, SQL, Databases, Excel, Access, MySQL, MSSQL.

Currently: CEO & Founder at WinPIS

Recent projects:

Virtual Forms for Microsoft Excel VBA (NEW UserForms for Excel VBA)

VBA Telemetry (connect VBA & Microsoft Azure Application Insights)

Recent projects in detail:

Virtual Forms for MS Excel VBA:

“Simple but powerful Userform control for Excel VBA so that anyone can use it, even without a single line of Excel VBA code!  “Create few sheets in ... See full profile

Class Ratings

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.

Transcripts

1. VBA Application & Usage Monitoring Online with Azure cloud - Introduction: you created a killing Microsoft Office document, Microsoft Access, Excel Word, PowerPoint or other that supports visual basic for applications. You've distributed them around the world to your users. But how do you know if there are any bugs? What parts of your document is used the most? Which function routine or part of the code is executed faster or slower on your users machines? Or are your office documents used it all? Now you can answer those questions with help from VB eight Telemetry and Microsoft A zero application insights. All you need is a free Microsoft as your account and a free version of VB, a telemetry client. Insert a few lines of VB a code into your office documents and enjoy how you're tracking data is flowing into your free Microsoft. Is your account ready to be viewed and analyzed by you from the author of the B B, a telemetry client dabbled gets with more than 20 years of programming experience, you will learn how to with just a few lines of BB eight code, connect your access itself or any other VB. A project with Microsoft Azure Cloud. This'll will give you the unseen opportunities and possibilities for improving and monitoring your VB A projects, no matter where the user is located in all that in real time. So don't wait. Take this course now. 2. How to create a FREE Microsoft Azure Account: in this lecture. Well together Go and great free Microsoft Azure account. We need to goto azure portal when you go to the Microsoft Azure portal and there will somewhere be a free account or start free, you can simply go and click too great a free account. Let's start free to create a free Azur account. We need to have a Microsoft account. If you don't have it, you can create one. Let's go and create one. Here. You can type in your inner address or, if you don't have one, we can also create a new email address for free. It's great one for free and the main outlook dot com. Let's feeling those details. It's feeling. Does verification called and we now have a new email address? No, let's stay a signing. That's good. Yes, let's now sign up with these new email address to our azure portal. Let's fill in those required fields just like your country type in your name. You type in your email address. It is going use this one that we just created. You need to put in your phone and you will also need to put in your credit card this is only for verification. Microsoft Azure will not charge you anything except you will allow it. So don't be afraid. You will not be charged. Let's put in these details. Ive here from Europe. You can put here your but I D But you can also put it later on. So we'll skip this step because it will not charge us anything so well. We will not get any bills for a company. Now it ask us for our full number. This is only four at the verification Made my phone you put in your phone number and tell the azure portal toe text you verification code. The verification cold should be sent to your mobile phone by SMS in about a few seconds. Put here the verification called that you have received on your mobile phone. No, it ask us for our card number. So don't worry. As it say's here In this message, we comprises slow by their friend that account holders are real people, not boats or anonymous troublemakers. Don't worry. Your card will not be charged on this. You explicitly convert toe paid offer so you might see a temporary authorization hold. I've been put here my card number when you're done with feeling. Had the cart information on this page. Click next and we need to sign the agreement. I agree, and let's go sign up as it stays here. We will start with 100 and 17 use grand. It's for 30 days after that. We will also have a chance toe be on as a reporter for the next 12 months in the free tire . And now we have a Microsoft Azure portal set up. No need to go with this tour. Maybe later. If you want to take a look, what is all included in this free tire? You can click here on most more services and type in the free. Then click on free services. You can see your unlisted services that are free for 12 months with an azure free account hero services that are available for always free and you can see here listed our application insights. We can create it from here, or we can go here, click on new and type in in the search box application insides application insights click on it, and here we can click on Create for the name for our research in the application insights we can type in what we want. Let's say this free in the application type, I will choose general subscription. We only have a free trial, a research group. You have already created some races groups. You can use the existing one. Or you can create a new group if you want to learn more. But research groups are you can go into the azure and documentation. Or we can create a new lesson that will be about the research groups in Microsoft Azure. But for now, let's great a new resource. Let's call it a resource free location. You can choose the location where you want toe. Create your application insights. Resource. The best place is where your users are, so I would choose West Europe. And if you want toe pain, this resource on your dashboard, you can take this check box and let's click create. Give Microsoft Azure a few seconds to create a resource, and here we have our first resource. The name is test free, and you can see that all is blank. There is no data yet here on your left. We can go down and creek on cost management and billing. He weaken. See the usage off for our Microsoft Azure portal. If you need to contact Microsoft Azure team for some help, you can do it from here. New support request and you can feel all these fields There will be. We'd you in a few hours or a few days, they will respond to your questions. Let's go back. So if you want to see your costs and subscription details, you can go here on the left and search for cost management and billing. Click on that Indoor were you? You can click on manage here on top. This will open a new tab. It will open all your subscriptions. If you only have these free trial, you can click on it. You can see that he's still active. It will open the summary for this pretrial. He would concede that we have 117 euros off credit remaining and that we'll also have 27 days left off our free trial. Unless you great here on upgrade now or here to convert automatically to pay as you go Azur or Microsoft Bill not charge you a penny If you go and experience some under azure portal resource is here. You will see as the days go by as you experiment, how much you spend on these azure resource is so I will once again tell you you have 170 euro credits and you have 27 days for free trial. After that, it will convert toe a free account that you can also use for 12 months at any time. You can cancel your subscription by clicking on cancel subscription here down. If you have any questions, you can contact Microsoft support and there will respond in a few hours off maximum in a day, sometimes two days. Once again, I will tell you, if you do not click here on upgrade now or here on convert to pay as you go after 27 days or when you spend all your creds that Microsoft gave to you, your cart will not be charged. You'll only be converted into a free account and you have some access to some services for next 12 months. But it will not charge your cart 3. Creating new Azure Application Insights resource: and I'll show you how you can create application in sight. Resource. Let's go click on a new Let's Search for complication Insights. Now you can click on Create. I was given the name just at one application type. I will choose General subscription. Reese is group you can create new If you don't have one, I will select one existing test results. You can read more about the research groups in the azure documentations location. Here you will select the server that ihsaa on the best location that you need, where your users are. And if you want toe train this research to dashboard, you can take this check box and let's we create. Give my Chris pleasure a few seconds to create your application in science researchers, and it will be placed here on your dashboard. 4. Overview of blank Azure Application Insights resource: here. We have our application in science research. We have named it test app. One as you can see, it is empty. There is no data for failures. There is no data users. All is still blank. 5. Resources & where to download them online (VBA Telemetry client & Excel Samples): No. Let's go and download a test app from Libya. Telemetry on site. Let's go again. Into dollars. You can see that we are on the page that we don't need anymore. Toe log in and we can download this This file. Let's save it to desktop. Okay? It has finished downloading. We don't need this anymore. Let's extract this Zip are here. 6. Installing VBA Telemetry Client: and in this folder this are You have three files. Read me first. You can go through this step by step, or you can just Iran. This will be a telemetry. Set up this real install a little Dellal in tow on this machine this day Well is needed because it will connect your we be a with the application inside client, you can simply double click it and go through the installation process. I have already installed it on this machine, so I will quit, okay? 7. Connecting your VBA Application to Azure Application Insights resource: Now it's open. Our simple track event simple sample enabled this content and it is already saying to us that we need toe insert the instrumentation key. I will show you how to do that. Going to developer tab into the usual basic that's going to the BB editor here. You can see that we are having a two models. If you want to implement way being telemetry into your existing projects, you can download these two modules from the VB a telemetry page, or you can simply copy paste it from here. In this first model, we have the functions that we can use and this second module we have some variables that we need to set up. The only mandatory required variable is this instrumentation keep. This is a limitation keep. We will get from our application insights research that we just great go into your Microsoft Azure application insights here into your ah test ap ah, into this test at that, we have created scroll down to where it say's properties. Here you will have your instrumentation key. For these researchers, this research is named test app, one same place copping this instrumentation key and based in here, you can save it and your World book is ready and it is connected to your application insights resource. 8. Sending Events to Azure Application Insights resource: Let's go once again in tow. Our look developer usual basic this world. Look, you can see that we already have. Two women's first event is workbook. Before close, it will send the event were book before close to the application insights researchers And also it will call the flesh function. This place function is needed because there we need to tell the application instead client that we're finished without work and that it can send the rest off the datum in tow. Our application incised research. Just a moment application incised client doesn't send the data immediately. As it happens, it stores this datum in a memory and then send these data toe the azure portal in some kind of chunks in a minute or two. We also have a second he went. It is on work open here. We hear instant this function track a man worked open. It will trigger this event on work open and it triggered this and went before we close our World book. Let's close it and we should have some data already in our application insights resource. Let's go into the events and we will refresh this page. And here you have the tour ends that they show you in a workbook, are recorded verbal before close and we're book open. Let's open this again. Let's go and opened this world once again And let's close it. Give Microsoft Azure application means side some time to collect the data. Let's try to refresh still. Oh there, three events. Okay, let's refresh once again. 9. Sending Custom Event from VBA to Azure: Let's add some custom events so that you can see how this works. Let's open this sample workbook and let's at some you sheet. Go to developer for Toe Insert Activex command button and let's insert a cold here. In this model, we can see what functions can be used. Let's use this tractor. Rent a copy and it's added to this command button one click event truck event, and we will sand this string into our application Inside researchers. Let's say it caused this go from the design mode into the Raanta mode and quickness, but and now let's go here. Let's ah, way the second. That's very the minute or two, and then we can refresh our application insights. Resource. We have five Ferentz. We have three verbal before close and two World Book Open rents. That's refresh it once again, and now we have seven events. We have workbook before. Clothes three times were good. Open three times and command button one click once 10. Quick Overview of Data sent to Azure Application Insights resource: Now let's see some under, uh, info. That's goingto the users here. We have one unique users because on Lee I am using this. I come from creation that the application version is 1.0. This is the data that is coming from this module. Here you can they find the version number application version. It is a 1.0. Here. You can see the user idea. This is my computer name. When piss seven sessions, seven events. Let's click on this user idea and here you can see into the detail. When this event waas fired, you can see my user i d. You can see the location where and I means our group in creation device that I'm using. I'm using Microsoft Windows Stand Total sessions and when I waas first using this application 11. Quick view of Advanced Analytics for Application Insights: you can also go in tow. More details. If you open the chart in analytics, this will open a separate application. You can right here your own squarest to see the data that you want more into. Details how toe use this application insights analytics. We will cover in some other videos or in some other Actiq ALS. Let's close this. 12. Tracking VBA Errors with Azure Application Insights: I want to show you how you can send the data about some errors. Let's go into our excel overbook into the V b a editor and let's singling some errors. Okay, let's do this on. No, que. Here we will. Great. An error. Divide by zero. What the? And on this error, but showed this message books and we were also record this in tow. Are Microsoft Azure application in sick for this, we will use our function. That is called track error. Make a copy of the whole function from here in. So here. Okay, maybe we'll provide an error message. This will be in the error description were also send Aaron number and where it happened. Come on. Okay, this is the same command, but one. Let's save this. What's exit this subverting. That's. And also, if air number zero only then Well, here. Okay, That said here. Well, let's say Rick Cools the baby Inter, and let's test division by zero. This is the era that we want toe trigger. Let's see, Let's save this on its exit so that an application will flesh the data so that we don't need toe. Wait long and we shoud have some on data in the failures that on here it is One user, one error. Let's click on this to see what was the error. Seven events, one exception. And here we have the exception division by zero. And these are the events, the customer events that we have trigger previously. From this exception, if you click on this exception, you will get some more data for this ever country Gracia my I p address operating system Microsoft Windows 10 State Grad Zagreb If you click here on C all properties, you can see division by zero and you can see all the properties that the application inside client has sent to our azure application. Inside resource, this is the session. This is the time This application version user i d. This is my computers user. I d it is exception or in our technology and ever, uh, air stack command button one click and enter number 11. There plenty of data and the information that you can get from this one line off code