VBA is not a scripting language… Not at all!
Imagine you have a spreadsheet with some numbers in it. And you need to read the first 130 numbers in the first 7 columns and save them in a list. Or something similar. Quite a strange task, but it happens …
Sometimes with Excel you receive an error message, saying “Too Many Different Cell Formats”. This is really hard to believe, because you have not done something bad or strange and yet you cannot finish your action. Still, Microsoft knows about …
VBA tools are important for any vba developer – today I was thinking to summarize the tools I am using daily and to update the list of them with the time. The order of the tools is pretty much random. …
Some time ago I had to open a VBA file saved as *.xlsb. The password protection for this was a little more difficult than the one for *.xlsm, thus after some research I have found a tool called VbaDiff, which claimed …
VbaDiff Review – VBA Software for source control with additional features Read more »
Ever building a code, which you would like to have in every program you make? Most probably. So, if you are coding in C#, this is the way to do it – through libraries. So, these are the steps: In …
This Wednesday I have not participated in the CodeForces competition – I was either too tired on Wednesday or I had something better to do. 🙂 Anyhow, I have just taken a quick look at the first two problems of …
Some one year ago there was something called Bayan 2015 Contest, published in codeforces.com. Thus, I have decided to solve one of the contest problems with VBA in Excel. And actually, as expected I have managed to do it! 😀 …
Some time ago I have reviewed the first edition of Excel VBA for non programmers. Thus, I was really flattered when the author has asked me to review the second edition as well. 🙂 The strong sites from the first …
Depth first search algorithm is one of the two famous algorithms in graphs. I am now in “Algorithm Wave” as far as I am watching some videos from SoftUni Algorithm courses. In the current article I will show how to …
The longest increasing sub sequence is a well-known problem in computer science, its Wikipedia page is translated into 9 languages. 🙂 Thus, as far as I am watching some programming and algorithms courses in the SoftUni, I have decided to …
Here I will show how to change classes in jQuery and to use classes and ids. The idea of the sample is really simple – we have two divs – one clickable and the other one not. Once …
I still remember when I first saw VBA some 4 years ago. I was already an experienced Excel user, and I really felt strange – I thought that I was losing so many hours and days with things that I …
At the beginning of January 2015, the Software University has decided to carry out an IT Olympiad. The competition problems and their solutions in C# are available here. In this article, I will present a way to resolve the second problem …
Working with VBA has its beauty. Especially when you need to build something like regex and you do not want to import a whole library for some reason, that is known only by you. Then you start googling and you …
So, after importing data to SQL Server from Excel now it is time for the reversing policy. Actually, much of the code was available in the Microsoft site here, but still, it was not all that I needed. I wanted to make …
MSSQL – Export data from SQL Server to Excel with VBA Read more »
Let’s imagine the following situation. You work in a small company, where one excel spreadsheet is used by many users locally. But you still want to see some kind of track of the results in a collected option. E.g. some information, …
MSSQL – Import data from Excel to SQL Server with VBA Read more »
So far in VitoshAcademy I have done the following ToDo apps: To Do with AngularJS To Do with PHP To Do with Python & Django It is not because I really have so much to do, but I really like …
VB .NET Just Another ToDo App with VitoshAcademy Read more »
As far as I am interesting in probabilities and similar theories in general, today I have decided to illustrate the WithEvents option in Visual Basic with the possibility to bet whether a rolled dice would be big (4,5,6) or small …
The game is indeed small, and really teasing… Actually, it has no interface, no gameplay, nothing. It can be used by professional CS players to train their mouses and brains. Or just to break their keyboard, if they are really …
Interfaces in VBA are something extremely rare. So far, as a VBA developer with about 3 years of developing experience (e.g. being paid to code, and not coding for fun) I have seen only one other developer to use classes …
Have you ever tought what is the best way to go in a matrix, in order to collect as many points as possible, if you are allowed to go only to the right and down? Imagine some matrix like the yellow …
VBA – Find the Best Way Through a Matrix, going Right and Down Read more »
There is a new article on the same subject here – https://www.vitoshacademy.com/vba-avoid-nested-loops-with-recursion-part-2/ Everyone knows how ugly it looks from a programming point of view to have 5 or 6 nested loops. But what can you do to avoid this? The answer …
VBA – Nested loops with recursion (Permutations) Read more »
Today I have tried for some time to do the following – make a picture ActiveX controller change, following the results of a dropdown button. The problem is that the picture ActiveX controller expects a path to the picture file, …
After the article here I have started to think more over the search algorithm and I have decided to make it look better and work better. E.g., by using the fact, that the distance between the diagonals neighbours is 1.4 times …
Today, some hours ago I saw the implementation of the A* search algorithm with Java, made by a classmate (or colleague) of mine. It looks like this: Thus, I have thought that for the reading of the Python Algorithm book, …
The idea of the VBA library is to systematize the most used self-written functions everyone is using in his daily coding life into a few modules, which may be used by anyone, who is coding for his daily bread and …
Have you ever thought how the web server acts in case that you enter an address, which does not exist? In many sites (including this one), you go to a fancy 404 page. This linking to that special page is …
While I am on the JQuery subject, with the previous article for the table game, I have decided to enrich it a little. 🙂 Thus, adding some nice animation functions for JQuery – fadeIn(); slideToggle(); slideUp, animate() and their back …
JQuery – fadeIn(), slideToggle(), slideUp(), animate() Read more »
Today, I will take a look at a problem, similar to the one here. In the article there, I produced a matrix, calculating the cheapest plane tickets between any two airports given. Today, the task is a little different. I would …
Python – Get the shortest path in a weighted graph – Dijkstra Read more »
Although I have started to learn new stuff lately, such as Python and SQL server, I am still interested in MS Excel and whatever is being published on the subject. I have noticed that the book “Pivot Tables Smart Data …