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 get Excel data using Python?

I already showed You how to get data from Excel file using ListObject and using SQL query in VBA. To make things more interesting I thought it is time for something way more different. In this article I’m going to shortly present how to get Excel data using Python.

(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 SQL query Excel data in VBA?

There are tons of ways to get the data from Excel worksheet. This one might be not so obvious at the first glance. In this article I’m going to show You how to query Excel data using SQL in VBA.

(more…)

Author: Tomasz Płociński

How to close SAP Logon window?

In all of my SAP based articles I showed You how to open SAP Logon, choose the environment, go to transaction, do whatever You need inside and then close the environment. In this one I will present to You the last thing, which I never show You before – how to close SAP Logon window.

(more…)