In this article, we want to present you 2 quick and efficient ways to get the difference between 2 specific dates or times via Word macros.
To calculate the days or time left between 2 concrete dates or times is of no difficulty. You can either do the math by yourself or get a date or time duration calculator. And here we want to demonstrate you the 2 macro ways which enable you to get the date or time difference in Word. Following are the detailed steps:
Get the Date Difference
First...
Read more »
Do you often use the attachment name as the email subject in Outlook? If so, you must hope that Outlook can automatically complete it. This article will introduce a handy method to make it realized with Outlook VBA.
Many users are accustomed to manually typing the attachment name in the email subject line. In such a scenario, if Outlook can auto accomplish it, it’ll be far more convenient. Also, some users often forget to fill the subject line. So, when hitting “Send” button, they will...
Read more »
This exercise shows how to read data from a website, in this case up-to-the-minute currency exchange rates from Yahoo.com.
It is assumed 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".
Prerequisites include a knowledge of populating combo-boxes and defining names.
The workbook consists of two sheets:
The User Interface:
The Buy and Sell combo boxes reference the local data sheet...
Read more »
