An update to the Shipment Tracking Add-In is available.
Continue Reading: Shipment Tracking Add-in Update »
Shipment Tracking Userform for batch processing
In my previous post Shipment Tracking Add-In for Excel I introduced an add-in UDF for tracking package shipments from UPS, DHL and FedEx. A few more caveats about that function:
- It appears to only work for domestic (U.S.) shipments.
- It does work for FedEx tracking numbers, but only the 12-digit version. There is a 22-digit version of the tracking number which you need to pass to the function directly as an argument (not as a cell reference).
Continue Reading: Shipment Tracking Userform for batch processing »
A simple sheet changing add-in
I wrote a small add-in that lets you switch between worksheets easily. Just download the installer and run the .EXE file, the add-in will be installed for you.
Continue Reading: A simple sheet changing add-in »
Forget about it!
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 up the development.
Continue Reading: Forget about it! »
Make your Office add-in version-independent
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 Office installed on someone's computer. I want it to be version-independent, so it loads no matter which version of Office (2000-2007) is installed on the end user's computer.
Continue Reading: Make your Office add-in version-independent »
Follow Me