Office Solutions

How to Read Data from Online Web Pages with Excel VBA

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 »

How to Auto Attach Specific Files When Sending Specific Emails in Outlook

Do you often need to attach specific files when sending specific emails in Outlook? If so, you may feel it tedious to add them manually every times. This article will teach you a quick method to achieve it with Outlook VBA. In my daily works, I am frequently required to attach specific files when sending specific emails. For instance, every week, I have to send an email to my superiors so as to report my weekly work. In this email, I will need to attach some specific files, including work...

Read more »

How to Auto Move Specific Emails to Specific Folders after Reading Them in Outlook

Many users desire to move specific emails from Inbox to other specific folders after reading them, which will keep the Inbox mail folder clean. But always moving manually will be cumbersome. This article will expose a quick method to realize it automatically. As usual, every incoming email will land into the Inbox mail folder in Outlook. So, in this case, Inbox folder will be cluttered up and be stuffed over time. More often than not, you can either manually move specific emails to other...

Read more »