Archive for the ‘VBA’ Category
Sunday, September 28th, 2008 88 views
Do you ever need to forward attachments to someone else (maybe your boss), but don't want the ugliness of "FW: FW: re:" in the subject line? Why let others choose how your emails are going to appear -- here's an amalgam of code I've posted previously (mainly from Processing multiple ...
Posted in Outlook, VBA | No Comments »
Friday, September 19th, 2008 103 views
In Delay Sending Outlook Messages, Debra Dalgleish writes about deferring delivery times for Outlook messages:
You hit Send, then realize you forgot the attachment. Or you misspelled the recipient’s name. Or you used Reply All, when you only wanted the message to go to one person. None of these things have ...
Posted in Outlook, VBA | 2 Comments »
Friday, September 19th, 2008 175 views
If you work in an office that uses public network storage (i.e. mapped network drives that everyone in your office shares access to), then you'll appreciate this next bit of code.
The page on sample Outlook automation from Excel shows some sample VBA code in Excel for creating an Outlook ...
Posted in Excel, Outlook, VBA, automation | No Comments »
Wednesday, September 17th, 2008 129 views
When creating a worksheet that needs to be filled in by a client/end user to collect data, you might want to require certain fields/cells to be populated. In other words, there may be certain cells like "Client Name" that need to be filled in, in order for the worksheet to ...
Posted in Excel, VBA | No Comments »
Tuesday, September 16th, 2008 79 views
If you are a trainer or maintain class enrollment schedules, here is a workbook that might
be useful to you. I spent about three days working on a training class schedule maintainer,
and it is available here to you along with the full VBA source code.
Download Training Scheduler workbook
For example, if ...
Posted in Excel, VBA | No Comments »
