Welcome to Simple Excel VBA

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.

Recent posts:

How to automate scrolling in SAP table?

Recently I received suggestion to dig in the problem of pop up table-windows in SAP, which content is bigger than its size. The funniest thing is that, it’s not issue only in SAP scripting, but also such software like Winshutle is having some troubles with that. In this article I’m going to get throught this problem and present You 2 ways of how to automate scrolling in SAP table.

(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.

How to copy object collection data to worksheet?

The main topic seems to be really simple and obvious, but the truth is probably quite different than You could expect. In this article I want to show You how to copy object collection data into worksheet, but faster.

(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.

How to create & use User-Defined Function (UDF)?

Usually there is already built-in function, which can meet your requirements. But sometimes this is not exactly what You needed or it’s not exist. In this article I will show You how to create and use User-Defined Function (UDF) in 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.