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:

Update PowerPoint chart data from Excel

We all know that in general Excel application is for calculations and PowerPoint is for visual presentation. So all the data is prepared in worksheet, based on which all the charts in PowerPoint are created. In this article I will show You how to update PowerPoint chart data from Excel using VBA.

(more…)
Tomasz Płociński

Author: Tomasz Płociński

Excel VBA enthusiast who is also open for other languages. Mainly working in VBA, some SQL, hungry for more.

Prevent formatting text as date by Excel

How many times You just wanted to type some numbers diveded with slash, dot or hiven and Excel was converting into date automatically and You didn’t want that at all? In this article I will show You how to prevent formatting text as date by Excel.

incel #excel - zapper-nunczako-vat - Wykop.pl
(more…)
Tomasz Płociński

Author: Tomasz Płociński

Excel VBA enthusiast who is also open for other languages. Mainly working in VBA, some SQL, hungry for more.

How to get rid of SAP scripting pop ups?

Everyone, who launched macro connecting SAP for the first time, have encountered this. Those 2 pop ups are destroying the idea of automation. You can’t record them and don’t know how to avoid them. In this article I’m going to present how to turn off SAP scripting pop ups.

(more…)
Tomasz Płociński

Author: Tomasz Płociński

Excel VBA enthusiast who is also open for other languages. Mainly working in VBA, some SQL, hungry for more.