Archive for February, 2008

Personal.xls workbook Not Available When You Start Microsoft Excel

Saturday, February 2nd, 2008 47 views

If you normally keep your macros in a personal.xls workbook (in your XLSTART folder) but suddenly it doesn't open, try this technique for restoring it. I assume you have already checked to make sure it isn't just hidden (Window>Unhide) or disabled (Help>About Microsoft Excel>Disabled Items). 1. Quit all instances of Microsoft Excel, ...

VBA Macro to Remove Stationery from Email Message

Friday, February 1st, 2008 31 views

While browing some other lovely VBA blogs, I came across this site with some really excellent code. I hate receiving Outlook emails with stationery, which I remove from my replies with extreme prejudice. This code will do so programmatically, which is a real treat. Check out the code here: http://adam.rosi-kessel.org/weblog/2008/01/26/windows-outlook-2003-tip-vba-macro-to-remove-stationery-from-email-message Enjoy, JP