Archive for the ‘automation’ Category
Friday, September 19th, 2008 100 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 10th, 2008 81 views
Here is a simple UDF that adds an appointment to your Outlook calendar. It can be used from Excel or VBA, and it should be usable from Access as well (untested). It uses another concept I've also been trying out: checking functions to make sure they are successful by using ...
Posted in Access, Excel, Outlook, UDF, VBA, automation | No Comments »
Saturday, September 6th, 2008 214 views
Here is the last of the add-in code I was working on. This piece extracts the properties from Contact Items into Excel, using early binding to speed up the code, but with GetObject/CreateObject calls to attempt to hook into an existing instance of Outlook. What, do you mean you don't ...
Posted in Excel, Outlook, VBA, automation | No Comments »
Friday, August 29th, 2008 312 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 »
Sunday, August 10th, 2008 554 views
I completed some VBA code that will allow you to export appointment information (meetings, appointments) from Outlook into Excel. It requires a reference to the Outlook object library (unless you care to reengineer it), but it works even with Outlook closed. I think you'll find it very useful for when ...
Posted in Excel, Outlook, VBA, automation | 2 Comments »
