In today’s post, we want to share with you 2 quick ways to extract individual pages from your Word document.
Sometimes in a Word document, each page may contain quite independent contents, such as a table. And you will probably need to send different tables to different people. Then you will have to save each table that is each page, as a separate file.
The first idea occurs to our mind should be the classic copy-and-paste. Yet, anything involves selection can be annoying sometimes, for...
Read more »
This article shows how to refresh a worksheet or chart at regular intervals. This exercise builds a timer that refreshes the worksheet every one minute, reflecting changes in the source data.
This article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google "Excel Developer Tab" or "Excel Code Window".
An example of the workbook used in this exercise can be found here.
Uses of dynamic reporting might be:
Reading the...
Read more »
When replying an email which has background color, if you would like to remove it, you can use the following 2 means introduced in this article.
Some users like to use their preferred background color in their emails. Thus it is believed that you may have ever received such emails which contain customized background color. If you dislike the color, you must wish to remove it when reply the email. As usual, to remove the color, you can manually change the “Page Color” to “No Color”. However,...
Read more »
