Import data from Access to Excel (DAO) using VBA in Microsoft Excel

CopyFromRecordset is probably the easiest method of getting data from an Access table to an Excel worksheet. Sub DAOCopyFromRecordSet(DBFullName As S...

Sort the data by birthday using VBA in Microsoft Excel

In this article, we will create a macro for sorting data in the sheet by birthday and we will not consider year while sorting the data. Raw data cons...

Import data from Access to Excel (ADO) using VBA in Microsoft Excel

With the procedure below you can import data from an Access table to a worksheet. Sub ADOImportFromAccessTable(DBFullName As String, _ TableName...

Export data from Excel to Access (ADO) using VBA in Microsoft Excel

We can export the data from Microsoft Excel to Microsoft Access by using VBA. Below is the VBA code and process which you need to paste in the code mo...

Add page breaks to sorted data using VBA in Microsoft Excel

  In this article, we will create a macro to insert page breaks, based on a certain condition. Raw data consists agent wise data, which include...

Enter the Weekdays Mon – Fri in a Worksheet using VBA in Microsoft Excel

In this article, we will create a macro to extract the weekdays between two dates. In this example, we have to specify start date and end date before...

Replace text in a text file using VBA in Microsoft Excel

The macros below can be used to replace text in a text file, e.g. when you want to change a column separator in a text file before you import it int...

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