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.
Continue reading “Add signature to your automated emails”Category: Excel
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.

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.

Customize your VBA editor (VBE)
Probably the most annoying thing in VBA coding is that the editor (VBE) looks like the time stopped for him a while ago. Unfortunately it is true in some case, because as far as I know Microsoft stopped to support VBA in 2008, but officially they did not say that until 2020. The case is not only the appearance, but most of all about functionality. In this article I’m going to present 5 VBE upgrades, which will customize your VBA editor to improve your user experience.
Continue reading “Customize your VBA editor (VBE)”Issue with UCase, LCase, Format, Mid etc in VBA
The most known situation in office environment – it was working on my computer, it is not on other. This time appeared compile error Can’t find project or library, but showing me UCase issue with highlighted code line. How code could loose the library for the basic VBA function?
Continue reading “Issue with UCase, LCase, Format, Mid etc in VBA”