Add-Ins
Seven Excel add-ins are now available!
- Data Filter Tool
- Sheet Picker
- Shipment Tracking
- Shipment Tracking Userform
- Random Data Generator
- Post To Twitter
- Amazon Ad Link Generator
The add-ins and files available on this site may not be redistributed without permission. If you find these add-ins on another site, I would appreciate if you would let me know.
1) Data Filter Tool!
The Data Filter Tool add-in does one thing: it filters a table of data and copies or moves matching rows to a new workbook. For example, if you have a list of addresses in Excel, with a column for State, this add-in lets you filter by State and copy (or move) all the rows matching a specific State to a newly created workbook. I guess you could say it's like Advanced Filter, but with a more intuitive interface. Headers are always copied, even if you select the Move option, to preserve headers in the original data. It preserves formatting of the original data (bold, italic, etc) but copies values, not formulas.
Screenshot:
Features:
- Filters a table of data based on column you specify, copies or moves records to new worksheet
- Does not delete headers, even if you select "Move" option
- Installs itself correctly, no matter how it is opened
- Menu item added to Data » Filter menu
- Reset button clears inputs for data entry of new range
Read my guest post on Mary's Pad about the add-in
Code Locked Versions:
Data Filter Tool Add-In – Excel 2000-2003 version
Data Filter Tool Add-In – Excel 2007 version
Code UN-Locked Versions:
Data Filter Tool Add-In – Excel 2000-2003 version
Data Filter Tool Add-In – Excel 2007 version
2) Sheet Picker Add-In, version 2.0
My second add-in is a simple userform that lets you switch between worksheets. If you have a workbook with many worksheets, it's a pain to switch between them. Sure, there are shortcut keys (Ctrl-PgDn, etc) and the right-click context menu, but this add-in makes it easy to navigate.
Version 2 now includes the ability to switch to any worksheet in any open workbook. Read my description of the Sheet Picker add-in
Code Locked Versions:
Sheet Picker Add-In – Excel 2000-2003 version
Sheet Picker Add-In – Excel 2007 version
Code UN-Locked Versions:
Sheet Picker Add-In – Excel 2000-2003 version
Sheet Picker Add-In – Excel 2007 version
3) Shipment Tracking Add-In, version 4.1.2
An add-in UDF that can be used to track packages from DHL, FedEx, UPS, Conway and ABF and return status information directly to the worksheet. Now includes CEVA and USPS! Uses XMLHTTP object for lightning-fast web queries! (ShDocvw.InternetExplorer used for ABF; Conway and ABF tracking added by site visitor Mike)
Read my description of the ShipTrack add-in and my announcement of version 4.0.
Requires msxml2.dll in your system32 folder
Code Locked Versions:
ShipTrack Add-In – Excel 2000-2003 version
ShipTrack Add-In – Excel 2007 version
Code UN-Locked Versions:
ShipTrack Add-In – Excel 2000-2003 version
ShipTrack Add-In – Excel 2007 version
Update 12/28/2009: Something seems to be wrong with the 2007 versions, and I can't figure it out. If you download one of the 2007 versions and can't open it, email me and I'll mail you a copy.
4) Shipment Tracking Userform
A companion add-in to the Shipment Tracking Add-In, this add-in provides a userform for batch tracking number processing. This add-in is specifically for batch processing; if you only need to track one or two packages at any given time, just use the ShipTrack add-in described above.
The ShipTrack add-in is required in order to use the userform add-in. You must have it installed before trying to install the ShipTrackUI add-in.
Read my description of the ShipTrack UI add-in (see also Shiptrack Update).
Download the ShipTrack Userform add-in for Excel
Requires msxml6.dll in your system32 folder
5) Random Data Generator Add-In, version 2.0
To comply with privacy regulations (HIPAA, Sarbanes-Oxley), organizations that handle sensitive consumer data (names, SSN, DOB, etc) should use fake data when conducting software tests. This Excel add-in allows the end user to generate quantities of fake data for testing purposes, data such as: Gender, Name (First and Last), SSN, DOB, Address, City, State, Zip, Phone.
Version 2 of the add-in includes new fields to be generated:
- Maiden name
- Country
- Suffix
- Prefix
- Middle initial
Read my description of the Random Data Generator Add-In
Links removed due to technical issues. They will be back shortly.
6) Post To Twitter, version 2.0
Post to your Twitter.com account from Excel. A GUI version of Chandoo's Twitter from Excel code.
Before and After screenshots:
Version 2 includes the ability to validate your username and password, and you can create a text file called credentials.txt in the same folder as the add-in, with your username and password, and it will pull your information from the text file so you do not have to type it in every time! Read my description of the Post To Twitter Add-In
Code Locked Versions:
Post To Twitter Add-In – Excel 2000-2003 version
Post To Twitter Add-In – Excel 2007 version
Code UN-Locked Versions:
Post To Twitter Add-In – Excel 2000-2003 version
Post To Twitter Add-In – Excel 2007 version
7) Amazon Ad Link Generator
This add-in is for webmasters and bloggers who use the Amazon Associates program to generate product links for display on their sites. Generate HTML links to any product of your choice, with your affiliate code baked right in!
Read my description of the Amazon Ad Link Generator Add-In
Code Locked Versions:
Amazon Ad Link Generator Add-In – Excel 2000-2003 version
Amazon Ad Link Generator Add-In – Excel 2007 version
Code UN-Locked Versions:
Amazon Ad Link Generator Add-In – Excel 2000-2003 version
Amazon Ad Link Generator Add-In – Excel 2007 version
The add-ins and files available on this site may not be redistributed without permission. If you find these add-ins on another site, I would appreciate if you would let me know.
Free != Public Domain
