Excel find all external links and broken links in workbook

This Excel tutorial explains how to find all external links and broken links in workbook using Find and Replace, Relationship Diagram, Macro. You may also want to read Excel VBA Workbook LinkSources Method Excel VBA refresh closed workbook Excel find all external links and broken links in workbook There are several ways to find external links and broken links in workbook, some are easy to use but have limitations, I will talk about each method in this article. Note that this article ...
Read More

Excel VBA refresh closed workbook

This Excel tutorial explains how to refresh a closed workbook. You may also want to read: Excel VBA refresh all Pivot Table or Pivot Cache Excel VBA AskToUpdateLinks Property Excel refresh closed workbook First of all, to refresh closed workbook involves opening the workbook, refresh and then close it,  it is impossible to refresh closed workbook without opening it, but we can open a workbook by vba without seeing it physically opened. Second, ask yourself what kind of refresh you ...
Read More

Excel timer countdown for test using Application.OnTime

This Excel tutorial shows how to make Excel timer countdown for test using Application.OnTime You may also want to read: Excel VBA Application.OnTime Method to schedule event with timer Send Email in Excel VBA using CDO and OLMailItem Excel timer countdown for test using Application.OnTime If you are going to job interview, you may be asked to do an Excel test. I have been thinking it would be awesome to make a countdown in the worksheet to tell the interviewee how much time is left. ...
Read More

Excel VBA Application.OnTime Method to schedule event with timer

This tutorial explains how to use Excel Application.OnTime Method to trigger / schedule event at specified time. You may also want to read: Auto Open Excel with Windows Task Scheduler Excel automatically refresh pivot table Excel VBA Application.OnTime Method to trigger event at specified time You can do the followings with Excel VBA Application.OnTime Method - schedule a procedure to be run at a specified time in the future - schedule a procedure to be run after a specific amou...
Read More

Excel Fill Blank Rows or blank Cells in inactive Pivot Table

This Excel tutorial explains how to use the value above to fill blank rows (blank cells) in inactive Pivot Table in Tabular format. You may also want to read: Excel Delete Blank Rows Excel VBA reformat merged cells to row Fill Blank Rows or blank Cells Excel Pivot Table Fill Blank Rows In Pivot Table, when you group an item in column, the same grouping name does not repeat itself and leaving blank rows. In the below picture, Division contains blank rows. In Excel 2010 o...
Read More

Send Email in Excel VBA using CDO and OLMailItem

This tutorial explains how to send email in Excel VBA using CDO and olMailItem. Send Email in Excel VBA using CDO and OlMailItem There are mainly two methods of sending email in Excel VBA. The first method is to use CDO Object, another is to use SendObject Method, I will explain each method in the below sections. Send Email in Excel VBA using olMailItem Object The first method uses olMailItem, it automatically sends email from the active Outlook account. The sender is whoever triggers the Ma...
Read More

VBA Excel Consolidate survey data

This tutorial explains how to use VBA Excel to consolidate survey data. Excel VBA Consolidate worksheets into one worksheet Excel VBA consolidate multiple workbooks into one workbook Excel VBA combine worksheets columns into one worksheet VBA Excel Consolidate survey data It is very difficult to describe what I meant to consolidate survey data, take a look at the below picture. The goal is to consolidate survey data as below. Normally, if you create online survey with Google, the r...
Read More

Excel VBA Consolidate worksheets into one worksheet

This Excel tutorial explains how to combine / consolidate worksheets into one worksheet. You may also want to read: Excel VBA combine worksheets columns into one worksheet Excel VBA consolidate multiple workbooks into one workbook Excel VBA Consolidate worksheets into one worksheet In this tutorial, I will show how to consolidate worksheets into one worksheet within the same workbook using VBA. Data from different worksheets will paste to the last row (same column) of the consolidatin...
Read More