Use a closed workbook as a database (DAO) using VBA in Microsoft Excel

With the procedures below you can use DAO to retrieve a recordset from a closed workbook and read/write data. Call the procedure like this: GetWorks...

Change text in header when printing using VBA in Microsoft Excel

Question: How Change text in header when printing . Place the code below into a regular Module. Sub VariableRow() Dim intCount As Integer, in...

Use a closed workbook as a database (ADO) using VBA in Microsoft Excel

With the procedures below you can use ADO to retrieve a recordset from a closed workbook and read/write data. Call the procedure like this: GetWor...

Calculations with one thousandth fractions of seconds by Custom Function using VBA

Question: Calculations with values in the area of tenthousandth of a second are to be done Answer: Insert the following code in the appropriate mo...

How to Transfer Specific Data from One Sheet to another through VBA in Microsoft Excel

In this article, we will use change event of worksheet to transfer data one sheet to another, depending upon a certain condition. Raw data consists o...

Import data from a text file (ADO) using VBA in Microsoft Excel

The procedure below can be used to get an ADO recordset from a text file and fill in the result in a worksheet. Sub GetTextFileData(strSQL As String,...

Import data from a closed workbook (ADO) using VBA in Microsoft Excel

If you want to import a lot of data from a closed workbook you can do this with ADO and the macro below. If you want to retrieve data from another wo...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube