How to connect to Microsoft SQL Server using VBA?

When it comes to big amount of data, Excel application is not the best solution to work with, in case of storage. Much better fit would be a database like Access or MSSM. In this article I’m going to show You how to connect to Microsoft SQL Server using VBA.

Continue reading “How to connect to Microsoft SQL Server using VBA?”

How to use class modules in VBA?

Class modules make VBA as truly object oriented programming language, like the other ones as Java or C++. At least a little bit. They are the way for You to create your own objects in the code. In this article I’m going to show You how You can build new objects using class modules in VBA.

Continue reading “How to use class modules in VBA?”

How to declare variables in VBA?

It is very good approach to declare variables in VBA. Of course You don’t have too, but I would treat that as privilege rather than obligation. This is so basic thing, but really important and can prevent from lots of mistakes. That’s why I want to show You how to proper declare variables in VBA.

Continue reading “How to declare variables in VBA?”

How to record macro in Excel?

You don’t have to know programming language to have your Excel tasks automated. Simply just record actions, which should be performed and launch it whenever You need. In this article I will show You how to record macro in Excel application.

Continue reading “How to record macro in Excel?”

Download file using WinHttp & ADODB method

I already described 2 methods how to download file from URL in one of my old articles. They are really good, but not the only methods. In this article I’m going to present the way to download file using WinHttp & ADODB method.

Continue reading “Download file using WinHttp & ADODB method”

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?”