Welcome to Simple Excel VBA

If You’d like to learn useful tricks in VBA in Excel and not only, You have come to the right place.

I invite you to Posts tab to read the latest entries. If You would like to search for articles You are interested in, use the search engine on this website and You will definitely find something in your area. There are articles on both simple and really advanced topics.

If you would like to just look at ‘funny’ pictures in the memes style, please visit the Memes tab. Maybe thanks to them you will be interested in the article they are in.

To contact me, go to About me or Contact me.

Recent posts:

How to create factorial function in VBA?

This time something different. We will go back to the math lessons. In this article I will show You 5 ways of how to create factorial function in VBA.

(more…)
Tomasz Płociński

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.

How to destroy Scripting Dictionary?

I love dictionaries! This is amazing object to create magical list of anything and to find any in just a second! But after they are not in use anymore, how to set them to nothing? How to destroy Scripting Dictionary?

(more…)
Tomasz Płociński

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.

Google Chrome automation with Selenium Basic

In my previous article I showed You how to scrap websites using good old buddy Internet Explorer. It is ok, but in case of more complex Java Script frontend sites our good old buddy might be not enough. In this post I will show You what You need to do to create web automation using Chrome with Selenium Basic.

(more…)
Tomasz Płociński

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.