How to return a result from VBA function?

As You may know, in general in programming to return a result from function there is Return statement. Even Visual Basic has it. Unfortunately there is no such thing in VBA. In this article I’m going to show You how to return a result from VBA function.

Continue reading “How to return a result from VBA function?”

How to destroy Scripting Dictionary?

I love dictionaries! This is amazing object to create magical list of anything and to find any in just a second! But after they are not in use anymore, how to set them to nothing? How to destroy Scripting Dictionary?

Continue reading “How to destroy Scripting Dictionary?”

Web automation using Internet Explorer

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.

Continue reading “Web automation using Internet Explorer”

How to get rid of SAP scripting pop ups?

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.

Continue reading “How to get rid of SAP scripting pop ups?”