VBA Tutorials
How to use API in VBA
In today's tutorial we will see how we can use API with vba in order to populate our spreadsheet with real world values such as stock prices and so
. . .
Create your first Add-In
Today we will see how to create an Add-In in excel in order to allow users to get an easy access to the customize controls directly in a custom tab . . .
SAP automation example
Hi there, I recently had to make a quick SAP automated process and thought that it could be interesting to present the test version here to give you a concrete
...
SAP automation
In this tutorial we will see how can we automate basic and repetitive task done in SAP through the use of VBA macros so if you're using SAP and do a lot of extract ...
Highlight vba formulas
This one will be drastically shorter than the one about custom ribbon as it only aims to present to you a quick tip which can come pretty handy when you're working ...
Excel Ribbon customization
Today we will go a bit further than the usual scope of our vba tutos and see how we can, through the use of both xml and vba, create our own custom ribbon that suits ...
Search Folder Command
This tuto will be just a quick presentation of the way by which you can allow the end user to select the source file from which to retrieve source data, through the ...
Class module tutorial
Today we'll be a bit different than usual as we will focus mainly on the creation and usage of class modules. Indeed, even though it is not a mandatory skills ...