Split array to increase performance

I already made article about how fast arrays can be comparing to Excel tables. You know that. You know also that arrays need some RAM memory to exist. But can we increase array performance with its split and descrease RAM usage? In this article I will show You if it is possible.

Continue reading “Split array to increase performance”

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”

Prevent from importing missing references

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”

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”