Archive for April, 2008

Internet Explorer Automation Object Library - Update for Excel 2007

Tuesday, April 29th, 2008 281 views

One of the most popular pages on this site shows code for automating Internet Explorer. However I have only tested the code in Excel XP/2003. The purpose of this post is to credit a gentleman named Durand Sinclair who, using Excel 2007, pointed out to me that the name of ...

Contribute to this site!

Tuesday, April 29th, 2008 32 views

It's not what you think. I'm asking for contributors to the VBA search engine! If you know of a website with VBA samples, or think you have what it takes to identify good websites with code, I'd like to know about it. Visit the VBA Search Engine Homepage and click "Volunteer ...

Event Code for Forwarding Selected Text to Another Email Address

Sunday, April 27th, 2008 80 views

Here is the event code I promised for forwarding emails to another email address. It does exactly the same thing as the previous code, but since it is event code, once you place it in a class module and restart Outlook, it runs automatically without any need for you to ...

Custom CSS tags for displaying well-formed VBA code

Sunday, April 27th, 2008 27 views

So you might be wondering, what does VBA have to do with a web technology like CSS? If you are like me and you hand-code your website, you might find it difficult to display VBA code properly. Unfortunately, I can't seem to locate a copy of zHTML, and the other ...

Forwarding Selected Text to Another Email Address

Thursday, April 17th, 2008 99 views

Greetings, I would like to share some code I wrote last month for a user who visited my website and asked for a macro that would look for specific text in the subject of an email and forward it to another email address (in this case, an email for a mobile ...