Over at Automated Word Mail Merge I have a sample workbook for creating a mail merge in Excel using VBA, but I've felt the example wasn't the best. So I produced another, and here it is.
Automation
Automation means any sort of interop between Office programs, for example, from Excel to Outlook or vice versa. This tag covers those types of articles.
An exploration of IE browser methods, part III
In previous articles I've written about how to extract information from webpages, and interact with them to navigate through a website.
This article won't strictly focus on IE, but on several collections available through the MSHTML Object Model.
Continue Reading »
Finding Constant Values
Here's a problem: You're automating Outlook in your Excel code (or any Office program for that matter), and need to find the value for an Outlook constant because you know you can't use built-in Outlook constants in late-bound Excel VBA code. How do you usually do it? Do an Internet search for the number?
Follow Me