Archive for August, 2008
Friday, August 29th, 2008 349 views
Here is part of the add-in code that exports Outlook Tasks into Excel. It works the same as the previous code that exports Calendar items, except we set a reference to the default Tasks folder (not Calendar), and I've also incorporated some new code which makes the sub more efficient ...
Posted in Excel, Outlook, VBA, automation | No Comments »
Tuesday, August 26th, 2008 54 views
If you have a text file to import, but only need some of the data, you could just import the whole thing and then manually scrub the data to find what you want. Text files can contain a lot more lines than an Excel worksheet, but much of it may ...
Posted in Excel | 3 Comments »
Tuesday, August 26th, 2008 46 views
When you are using early bound code for your own personal applications, it's easy to ensure that the proper object libraries are referenced: Simply go to Tools > References and check off the libraries you need. Then you can code using fully qualified references like "Excel.Range" and "Outlook.Application".
If you are ...
Posted in AddIns, Excel, VBA | 2 Comments »
Monday, August 25th, 2008 9 views
After much deliberation, I've decided to stop working on the Excel add-in I was creating to export Contacts, Tasks and Appointments to Excel. I haven't been spending enough time working on it, and rather than continuing to procrastinate, I've decided to just release the source code and let others pick ...
Posted in AddIns, administrative | No Comments »
Monday, August 25th, 2008 198 views
Ever wanted to have an army of pre-formatted emails, which you can send at the click of a button, but couldn't figure out how to programmatically insert your signature at the end? Here's one method that should work for you.
First you should make a note of whether your signature is ...
Posted in Outlook, VBA | No Comments »
