Video on how to start and create your desktop Microsoft Excel Apps with Virtual Forms without coding.
Here you can watch the video and download the related examples and resources.
How to create and show Professional & Paginated Excel Reports without Power BI using Virtual Forms free Report Viewer control for viewing & Microsoft Report Builder for SSRS for creating Paginated Excel Reports.
Paginated reports or "pixel perfect" reports are long the standard report format in SQL Server Reporting Services and they are now also available in Power BI.
But starting from April 2020. the paginated reports or pixel-perfect reports are also available to Excel, Access, Powerpoint and Word users, Python developers and any other development environment that supports ActiveX technology thanks to the free Virtual Forms Control.
This means that you do not need any license to create or use and display paginated reports.
Create your paginated reports or pixel-perfect reports with free Microsoft Report Builder and display them to your users with the help of the free Virtual Forms Control component that contains the Report Viewer control.
You don't need Power BI or any subscriptions to be able to display your paginated reports in Excel or Python (we can say that this are power bi paginated reports without premium).
All you have to do is install the Virtual Forms Framework, which contains a free Virtual Forms Control that will allow you to display your pixel-perfect paginated reports.
Then this video course is just for you.
I'm Davor Geci the author of Virtual Forms.
See us inside the course.
- 7.5 hours on-demand video
- 42 downloadable resources
- 2 articles
- Full lifetime access
Step-by-step Masterclass: Create quickly Excel VBA desktop apps using MySQL & Virtual Forms & VBA Excel 2010, 2013, 2016
Microsoft Excel & Microsoft Power BI are the most popular and used tools for analyzing and visualizing data.
BUT, Microsoft Excel is not created for gathering data, especially in gathering relational data like master-detail structures.
One basic, simple Excel example. You want to gather (or track) Orders in Excel and then for this Orders you want to track Order Details and, for example, Order Payments and all that using Excel.
Not to mention, to do this in a multi-user environment also in Excel
Boy,….., You will have a tough time to do this with Excel, because Excel is simply not created for challenges like this, to gather master-detail data and also in a multi-user environment within the normal Excel environment.
But in this course “Create Excel VBA apps using MySQL database & Virtual Forms“, You will learn how you can do this by using Excel VBA as a front end and MySQL database as a backend, whether the MySQL database is on your local machine, your local network, or on the web server. We will do this with help of a small tool called Virtual Forms.
I’m Davor Geci the CEO and the Lead Developer of WinPIS, the company that’s behind a popular tool that brings to Excel what Access developers are having for decades.
It is the ability to create CRUD Forms in Excel, forms to create, read, update and delete records that are stored in databases like MySQL, MSSQL, Access (On-premise or on the web) and use the data within Excel VBA and all that in minutes.
It is similar to what Access can do, but you could also port this Virtual forms from Excel VBA to Visual Studio 2017 (C# or VB.NET), Python,....
You can not do this with Access VBA or natively with Excel VBA !
So, you just need to create a database and tell the Designer which fields you want on your form that is opened from Excel VBA code.
Once created Virtual Forms can be also used as LookUp forms in Excel VBA with no extra work, just as you would do VLOOKUP an HLOOKUP in Excel functions & formulas.
All the controls that are generated on this Virtual forms can be accessed with Excel VBA (or if you use Visual Studio 2017 with C# or VB.NET).
Virtual form control also fires events, so it allows us to interact with it, in a similar way normal UserForms in Excel VBA do. But in a more data-centric way.
Before you dive in, it’s probably a good idea to just check out the structure of the course “Create Excel VBA apps using MySQL database & Virtual Forms”.
In this course, You will learn how to quickly create database applications using Microsoft Excel VBA and a MySQL database that is hosted somewhere on the internet or in your building (so-called on-premise) and all that with help of the Excel VBA & a small tool called Virtual Forms.
In the first part of this course, You will learn how to create your first database app that will use Excel VBA as a front end, and a MySQL database as the back end. You will also learn how to install a MySQL server on your machine or anywhere in your network and use it as a data source. Also, in the first part of the course, you will learn how to install and use MySQL Workbench that help us to create and maintain MySQL databases.
Don’t worry, I will go slow!
Not only you will learn how to create your Excel Virtual Forms and write a few lines of Excel VBA code to master them,
you will also learn how you can make money with your Excel apps by leveraging an affiliate program from a 3rd party web hosting company where you will host MySQL database.
And then, you will also learn how to transform your Excel VBA database applications with MySQL database as the datasource to C# or VB.NET with almost no change to the Excel VBA code.
We will also create Excel apps with other datasources, like Microsoft Access database and Microsoft Excel Workbook.
So, enroll now, try it out, learn new things in Excel VBA and MySQL, have fun with me and create your Microsoft Excel VBA apps in minutes.
Join me inside NOW!
- 39 mins on-demand video
- 3 downloadable resources
- 2 articles
- Full lifetime access
Create quickly Excel GUI (no code) or Python GUI (6 lines of code) Windows desktop apps using Virtual Forms
You will learn the Basics of creating a Professional Excel GUI or Python GUI Windows desktop database application in under 15 minutes without coding in Excel or with just 6 lines of code in Python using a tool called Virtual Forms Framework in this Excel & Python tutorial course.
We will create a simple Virtual Form that is able to (CRUD):
Delete records from database
Filter records in the Grid control with build in Filter functionality
No code in Excel or only 6 lines of code in Python.
You need to see this!
If you want to impress your boss, colleagues, clients and also impress yourself with Excel and (or) Python, Enroll in this course NOW!
See us inside,
- 30 mins on-demand video
- 2 downloadable resources
- 2 articles
- Full lifetime access
How to in real-time & online track Events, Metrics, Errors & usage of your VBA projects - Excel Access Word PowerPoint
Excel VBA Application & Usage Monitoring Online with Azure.
In this course 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 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 course NOW!
- 1 hour on-demand video
- 1 downloadable resource
- 1 article
- Full lifetime access
Track usage of your Microsoft Excel workbooks in real-time with Google Analytics for FREE.
Nothing to install, nothing to buy and no Excel VBA coding needed (I've already written all the necessary Excel VBA code for you).
Want to know if your boss, your colleagues or your clients did open your Excel Workbook report that you have sent them, without calling them 5 times a day?
Want to see if, or when they opened the Excel report? Did they take a look at, for example, Worksheet5?
You could call them and ask ....... again.
Or would you rather see and be informed when they opened it and what parts of your Excel workbook did they take a look at?
Now you can and also in real-time.
No coding, nothing to install, no tools to buy. Just a free Google Analytics account and your Excel Workbook.
This is all you need.
You will also learn how you can identify the most engaging medium or source for your Excel Workbooks.
Nothing to install, nothing to buy and no coding.
Let me explain, for example, if you want to use your Excel workbook as a lead magnet or just want to share your Excel files with other people in some Facebook or LinkedIn groups, download pages, or on other webpages where your users or potential leads hang out.
Until now you could only get the total number of downloads from these sources, but in this course, you will also learn how you could identify the source or medium where your most engaging users of your Excel workbooks are.
By enabling the tracking of your Excel workbook and before you put your file on this download place you can add a medium property to your tracking so that you can see in your Google Analytics account where your most engaging users are.
I'm Davor Geci, a CEO and an IT developer for more than 20 years. Let me show you these secrets of Microsoft Excel and Google Analytics that you can't find anywhere else. Why? Because Microsoft & Google are competing for the same piece of pie for decades.
So join me in this course and let me teach you these secret combinations and more tips and tricks on Microsoft Excel and Google Analytics.
Let me explain:
You send your Excel workbook to your boss, colleague or client, he opens it and you can see it in real-time in Google Analytics when this happens, or even see what worksheets they viewed and what clicked.
Now you can!
Add tracking code to your Microsoft Excel file and you will see it in minutes.
Do not stay uninformed, do not call your boss to find out that he has long since opened and seen your Excel report.
Did he also take a look at, for example, worksheet no 5?
No need to call him again, just take a look at your Google Analytics and you will see it if he did open the Workbook, when he did open it and did he take a look at that Sheet2.
Nothing to buy, nothing to install you just need a free Google Analytics account and a few minutes to get you started and see how it works.
I've already written all the necessary Excel VBA code for you.
So you don't need to write a single line of Excel VBA code to track your Excel workbooks with Google Analytics.
Now you can track your Excel workbooks on a UserID level.
Don't believe me? Take this course and you will see and learn how to do it.
Don't wait, enroll now!