What exactly are early and late bindings? This is what MSDN tells us about it: The Visual Basic compiler performs a process called binding when an object is assigned to an object variable. An object is early bound when it is assigned to a …
After 5 articles, concerning Java I decided that it is time to write one for the VBA – the language which many programmers do not consider such, and yet it is powerful tool, if you are an Excel or Access …
Hi there, if you ever need a quick renamer of files in forlders – that is the VBA code you may use: Option Explicit Sub ChangeNames() Dim fso As New filesystemobject Dim fol As Object Dim fil As Object Dim …
VBA – Quick Renamer of files in folders with VBA Read more »
In this post I will simply show a few VBA tricks, for defining last used cell in a row (or column) and defining the size of the worksheet. Let’s assume that you wish to delete all the contents from a …
VBA – Defining last cells in row/column and size of spreadsheet Read more »
VBA is a Microsoft script language, mostly used with Excel. And there are reasons for this – mainly, the skills needed to use VBA are easily grasp by those, using Excel on a daily basis. The second reason is that …
After showing some tricks for VBA MS Access, I have decided to go back to the field again to find a way to export a table in HTML format. Actually, VBA and Microsoft have taken care of the issue (no …
VBA – Access – Export a table in HTML and other tricks Read more »
In this article, I present 5 useful Excel worksheet based tricks: Set a date and time for the beginning of the latest update on the sheet; Color the changed cells in red; Change the sheet name based on the value …
After the first article for custom excel formulas with VBA (here) I have decided to enlarge my knowledge in the area with some additional examples. Here I present three different custom formulas for excel. 1. The first one is an …
You know, a lot of people nowadays should simply take loans. There are plenty of load calculators available online, but it is always better whey one can calculate this thing by himself. Or with Excel, which is pretty much the …
In this article I present a good possibility to customize your Active Window from Excel itself and not from the ribbon. By inserting some form controls, we receive a decent-looking customization dashboard like the one below: The idea of the …
With this macro we do not actually add something new – it simply does something, which is quite useful if you are working with big documents where you should select the data, based on different values. In the current example, …
VBA – Excel – Activate Sheet Based on Value on Another Sheet Read more »
Changing formulas to values is something really easy in MS Excel – what the majority of people (including me) would do the following – simply record a macro, where you select all cells and paste them as values. The result …
Probably, if you are programming with Excel as much as me, one day you have the following question – all the pictures in Excel are generated by my code and I really do not care to give them names. I …
VBA – How to delete quickly all pictures from Excel? Read more »
Lesson 1 – VBA and Excel What is VBA? – VBA is something great, if you are working more than 1 hour with MS Excel and MS Access. It is simply said a must for everyone, who earns his money …