If you would like to send an Excel worksheet as an email, instead of adding it to an email as attachment, you can use the two methods introduced in this article.
At times, unlike attaching an Excel file to an email as attachment, you may desire to directly insert an Excel worksheet in the email body, in other words, send it as an email. In response to this requirement, you can apply either of the following 2 means depending on whether you want to send in MS Excel or MS Outlook. Now read on...
Read more »
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 »
