An update to the Shipment Tracking Add-In is available.
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).
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.
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.
Follow Me