VBA – Opening and closing Word from Excel
Do you know that VBA can take over all the control over different MS Office applications? This is a simple example how you can open and close a Word application from Excel. In order to do this, you may use …
Year: 2013
VBA – Custom Excel Formulas
In this article I will show how to make custom MS Formulas. This is quite useful, if you want to use a formula, which is not available in the predefined Excel formulas. The inspiration for this article came, after I …
VBA – Puzzle Game in Excel
So, in this post I will show you a puzzle game in MS Excel – it is like the old one, the kids from the ’90s used to have, before we had PCs. So, the excel file is here, just …
C# – Quick Exchange Rate Calculator – Video
Hello All, I have created a small video, showing how to make use of the do-while loop for creation of small console applications. The interesting part of the code is the usage of the do-while loop, which executes the code …
MS Excel – Indication of duplicate values
An hour ago I had to look for duplicate values in a spreadsheet. I looked for a minute in google and found plenty of solutions, as you can imagine. One of the best was described here, but it is quite useless, …
C# – Creating a Matrix – Video
I have just made my first YouTube video!In it I create a matrix and I fill it up, using different directions. The size of the matrix is read from the Console. Or with other words, if the number is 5, …
VBA – How to start?
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 …
C# – Arrays
This is part the first C# problem, from arrays, given at Telerik C# 2 courses. Check it out. The problem itself is put as comments in the first two lines. In general, one should write a simple console application, which …