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.
Continue reading “Prevent from importing missing references”Category: Excel
How to detect wrong username or password in SAP
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.
Continue reading “How to detect wrong username or password in SAP”Video tutorial: Get your site status – WinHTTP Request
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!
How to manage with copyright window in SAP
The copyright window is the information, which is popping up when You are changing the language of your sessions. In this article I’m going to show You the simple trick of how to avoid this copyright window in SAP.
Continue reading “How to manage with copyright window in SAP”Video tutorial: How to declare array in Excel VBA
In this video I’m presenting to You three methods, which I’m mainly using in my codes – array as range, loop to array and array as words list.
Watch it here or go to my channel.
Enjoy the video, please leave a like and subscribe!
Looping performance 2 – can I speed it up?
After last tests I was not so surprised, but still proud of myself that found the difference between all in one loop and separated. However, I still felt a bit unsatisfied with possibly existing, other solutions and speed up looping performance. That’s why I decided to implement further modification.
Continue reading “Looping performance 2 – can I speed it up?”