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 ...