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 →
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 …
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 …
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. …
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 …