You’ve come to the right place of simple solutions & useful tricks in VBA in Excel, other Office applications (Word, PowerPoint…) and external apps (SAP, Internet Explorer…) too!
I invite you to Posts to read the latest entries. Use search engine to find articles You’re interested in from this website.
If You are better watcher go to Videos to watch some tutorials of mine from my YouTube channel.
Visit Memes gallery to see my collection of articles main pictures, also stored on Pinterest profile.

Go to About me to contact me.

How to connect to Microsoft SQL Server using VBA?

When it comes to big amount of data, Excel application is not the best solution to work with, in case of storage. Much better fit would be a database like Access or MSSM. In this article I’m going to show You how to connect to Microsoft SQL Server using VBA.

(more…)

Author: Tomasz Płociński

I'm very advanced in VBA, Excel, also easily linking VBA with other Office applications (e.g. PowerPoint) and external applications (e.g. SAP). I take part also in RPA processes (WebQuery, DataCache, IBM Access Client Solutions) where I can also use my SQL basic skillset. I'm trying now to widen my knowledge into TypeScript/JavaScript direction. View all posts by Tomasz Płociński

How to use class modules in VBA?

Class modules make VBA as truly object oriented programming language, like the other ones as Java or C++. At least a little bit. They are the way for You to create your own objects in the code. In this article I’m going to show You how You can build new objects using class modules in VBA.

(more…)

Author: Tomasz Płociński

How to declare variables in VBA?

It is very good approach to declare variables in VBA. Of course You don’t have too, but I would treat that as privilege rather than obligation. This is so basic thing, but really important and can prevent from lots of mistakes. That’s why I want to show You how to proper declare variables in VBA.

(more…)