Make your office life easier with simple and fast Excel VBA solutions.
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.
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?
Working as VBA developer brings a lot of different issues. One of the obstacles is the Office version. Apart of various behaviours of the same thing, there always will be something new, which was not avaiable in the previous version. In this article I’m going to show You how to prevent from importing missing references.
Mistakes happen. There is always a possibility to type wrong your credentials. Also SAP from time to time ask You to change the password, so that already written in code will be out of date. In this article I’m going to show You how to detect wrong username or password typed in SAP.
In this video we are going to get through the example of WinHTTP Request code to check the site status.
Watch it here or go to my channel.
Enjoy the video, please leave a like and subscribe!