VBA – Make Excel talk to you
Talk to me, Excel! 🙂 Yup, MS Excel can talk. In my case with a computer voice, which is close to a female one 🙂 How can you make use of it? I propose with a custom formula, which simply …
Author: Vitosh
VBA – Excel function for union of ranges
This would be a rather small article. Roughly, what it does is to take all of the cells in given range and to join them one by one, in a way to display them in a shape. Still with me …
VBA – Merge horizontal cells with equal values in Excel
If you work as a VBA developer long enough, you may find quite interesting tasks to appear in front of you. Sometimes you have to merge horizontal cells with equal values. And because you are not going to do in …
VBA – Merge horizontal cells with equal values in Excel Read more »
Book Review – Excel VBA: for Non-Programmers (Programming in Everyday Language)
The current article reviews a VBA book for MS Excel. First things first – I am not sure what should be done to pursue the non-IT people, that VBA is not something difficult and every hour you spend, trying to …
Book Review – Excel VBA: for Non-Programmers (Programming in Everyday Language) Read more »
VBA – Highlight cells with formulas
In the current article, I will show how to highlight only these cells, which contain formulas in the current Excel sheet. This can be useful, for a better orientation in the spreadsheet. With the property: .SpecialCells(xlCellTypeFormulas) we quickly grasp, whether …
VBA – Transfer data from Excel to Word
With the current article I will show you how to transfer data from Excel to Word. I will use Office 2010 and windows 7. In the first code snippet, I declare 2 objects and a range. The first Object …
VBA – Populate data in Access table with VBA
Sometimes you may need to populate data in Access table with VBA. This is actually quite useful, when you are building VBA Access tools. In the current example I will use hardcoding for the data entries, which are to be populated, …
VBA – Show all available fonts in MS Word
We know that VBA is also available in MS Word. Very few people use it, and they do it for a reason. Whenever you say that you are an Excel programmer, the “Hard Core” programmers kindly laugh at you and …
VBA – Save text from filtered table in Excel in separate file
I the current article I will simply present how to save the results from a filtered table in MS Excel in a separate text file. To do this you simply need some table as the following one, where you can …
VBA – Save text from filtered table in Excel in separate file Read more »
VBA – Excel custom functions – Document Properties
If you program with Excel and VBA, probably you have plenty of various functions, showing you how to access some of the file properties. Mainly file path and file name. With the current VBA module, you may see how to …
VBA – Excel custom functions – Document Properties Read more »
VBA – Save a Chart as a Picture (Gif)
With the current article I will simple present some easy code, transferring Chart (diagram) to a picture. It is not something unusual, but sometimes it may be very handy, if you are trying to use the picture later. So, let’s imagine …
C# – Enumeration – Classes builders
This week I have started again to look into Object Oriented Programming with C#. Thus, I have built a small example of OOP, using Enumeration. In the example I have two classes – the class “RunningCar”, containing the Main method …
C# – Defining Classes – SoftUni Homework
Some time ago I wrote a homework, concerning building classes. The easiest part of it looked like this as a task: Define a class Person that has name, age and email. The name and age are mandatory. The email is optional. …
VBA – Create Query with VBA
There are many ways to create a query in Access. However, creating a query with VBA code is something quite challenging. The code below creates an object of type query, named “MyQuery”. The SQL of the object is also given …
Book Review – Advanced Quantitative Finance with C++
Today, I have finally found some time to finish the reading of Advanced Quantitative Finance with C++, a book provided to me kindly by Packt Publishing. So, what the book says? Pretty much, it uses C++ for mathematical modelling. The …
Book Review – Advanced Quantitative Finance with C++ Read more »
Book Review – HTML5 Games Development by Example
At the beginning of August I have started to read the book HTML5 Games Development by Example, provided to me kindly by Packt Publishing. The book tells us exactly what is written at the title – it shows you how to …
Book Review – HTML5 Games Development by Example Read more »
VBA – Access – convert “HH:MM:SS” to double and back
MS Access is something very … interesting. For the last week I was building something on it, which includes dealing with data in HH:MM:SS format. Access has a pretty good feature for dealing with this, but this feature somehow crashes …
VBA – Access – convert “HH:MM:SS” to double and back Read more »
Java Script -Build a Table – Exam Problems
On 27. July I have participated in an exam organized by the SoftUni for Java Script. This time, I managed to get 220 points out of 400, which ranked me in 58th place out of 204 participants for the day and …
Java Script -Reveal Triangles – Exam
As I have mentioned in the previous post, I have participated in a Java Script competition from the SoftUni, where I made it to the top 31% of the competition 🙂 (not something to be extremely proud of, but considering …
VBA – HH:MM:SS from Minutes – Format in Access(Excel)
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 »
VBA – Getting column name from number in Excel – Function
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 »
VBA – Displaying the available AddIns in Excel
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 …
VBA – Early and Late Binding
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 …
Java – Exam – Congate Words
Some time ago, to be more honest last Sunday, I participated at some Java exam again. The results were not something to boast, quite on the contrary, but I did not have a lot of time to prepare 🙂 The …
Book Review – Learning Android Intents
During the last few weekends I was busy reading the book “Learning Android Intents“. As far as I am kind of developer with NO Android dev. experience, the book was interesting for me, due to the fact that it is …
Java – Exam – Couples Frequency
In the last java articles I have solved (or commented) the exam problems, given at the Java exam at the SoftUni. I have started with the easiest tasks (in my opinion) and I have gradually came to the toughest ones. …
Java – Exam – Pythagorean Numbers
In this article, I will comment the original solution for the Pythagorean numbers problem from the SoftUni Java contest. You have the following input – first a number N, telling you how many numbers you would have. Then you simply …
VBA – Mailing Excel Range as attachment
In this article I will show some easy code, that you can embed in your Excel tool, if you want to send its used range as an attachment. The code, I present is a little hard-coded, but it can be …
Java – Exam – Longest Odd-Even Sequence – Challenge!
As you probably know, for a long time (about 5 weeks) I started to learn Java from scratch. Today, I have decided to take a look at one of the exam problems at the Software University and I have spent some …
Java – Exam – Longest Odd-Even Sequence – Challenge! Read more »