Excel VBA: Display File Name as Hyperlink

In this article we will show you how to display file name as a hyperlink to a file in Excel. We first introduced this concept in this article but will expand upon it here. For this we will use the Hyperlinks.Add Method. Let’s have a

Data type mismatch in criteria error box

ByRef Argument Type Mismatch Error: Fixes

In this article, we will look at the ByRef argument type mismatch error. First, let us have a look at what is ByRef and the difference between ByRef and ByVal. In Visual Basic, you can pass an argument to a procedure or function by value or


Updating Tables in an Access Database Using Excel VBA

In this article, we will see how to update records in Access database through Excel VBA using ActiveX Data Objects (ADO). Let’s say you have a database named “Products". In that database, there is a table “ProductTable" that contains the product details of your business