Today I was building some Access DB, where I had to sum two variables in HH:MM:SS format. Then I had to multiply them by one integer and at the end to display them as HH:MM:SS once again. It seems really …
VBA – HH:MM:SS from Minutes – Format in Access(Excel) Read more →
Long long time ago, when I was building some Excel VBA spreadsheet tool for a leading retailer, I was having some cheat-sheet in Excel, in order to find the number of the column in Excel – e.g. A-1, B-2, C-3 …
VBA – Getting column name from number in Excel – Function Read more →
With the current article, I simply present a good way to list all the AddIns you have in MS Office, using VBA. Pretty much, I declare a string array and I redimensionize it. Then for each addin in the …
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 …