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...

Distribute Data from a List of the day to day sheets using VBA

  In this article, we will create a macro to arrange data day-wise on multiple sheets. Raw data for this article consists day-wise sales data o...

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 Google PlusVisit Us On Youtube