Seperating Website Name or URL from Text

The tip submitted by: Jay Shukla Some times we have a situation like: 1. Yahoo website www.yahoo.com 2. Google Website www.google.com So How...

Copy data having date between two defined dates to new worksheet using VBA

 In this article, we will create a macro to extract data from raw data worksheet to a new worksheet, based on the specified date range. Raw da...

List, change or delete external formula references (links) using VBA in Microsoft Excel

With the macros below you can find and delete formulas in cells that refers to other workbooks. The macros doesn't find all external references since...

List all the workbook links in a workbook using VBA in Microsoft Excel

Place the code below into the standard module Sub ListLinks() Dim aLinks As Variant aLinks = ActiveWorkbook.LinkSources(xlExcelLinks) ...

Delete all cells with data from previous dates using VBA

In this article, we will create a macro to delete data of previous dates. This macro checks the data, keeps today’s data and deletes all the data fr...

Launch Word file from Excel VBA

In this article, we will create a macro to open word document. To open a word document, we will specify full path of the document in the text box on ...

Execute Command/Sub-Procedure Using VBA Timer

In this article, we will create a macro to call another macro or execute a command after defined intervals of time. To execute the macro, cli...

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