Archive for the ‘AddIns’ Category
Tuesday, September 23rd, 2008 75 views
I wrote a small add-in that lets you switch between worksheets easily. Just download the XLA file, place in your favorite directory, and go to Tools > Add-Ins and browse for the file.
When installed, a menu item on the Windows menu called "Sheet Picker" is added. A form with a ...
Posted in AddIns, Excel | No Comments »
Tuesday, August 26th, 2008 47 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 »
Friday, July 25th, 2008 290 views
If you are working on code for any Office application, you might need to reference an object library for another Office application. I've been working on code for a new add-in for Excel, and needed to write code that would reference the appropriate object library, depending on the version of ...
Posted in AddIns, Excel, VBA, automation | 6 Comments »
Saturday, March 29th, 2008 22 views
Good morning,
I am pleased to announce that the Data Filter Tool add-in has been completed. I will be posting a fuller announcement on The Coding Pad, but for now I would like to make this add-in available for anyone who wants to try it.
Link: Data Filter Tool Add-In
Enjoy and please ...
Posted in AddIns, Excel, VBA | No Comments »
