Make your office life easier with simple and fast Excel VBA solutions.
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.
Do You want to have the same automation in web as in your Excel or SAP? In todays article I’m going to show You how to create web automation using good old buddy Internet Explorer.
Tired of issues connected with email automation in Outlook application? Here is another one! In todays article we are going to get rid of it and learn how to add signature to your automated emails.
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.
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.
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.
