Add-in Updates
April 16, 2009 • JP • No Comments • Rate This Article
• Links to this article
There are several Excel add-in updates available. Mozy on over to the Free Excel Add-Ins page to check them out.
1) Data Filter Tool
The Data Filter Tool has been slightly refaced, Help As You Go has been removed, and there are now locked and unlocked versions for Excel 2000 through 2007.
2) Sheet Picker
Sheet Picker has been updated to allow you to choose from any worksheet in any open workbook. Uses an event driven class module to identify when workbooks are open and closed while the add-in is running. Will not display hidden workbooks.
3) Random Data Generator
RDG version 2 includes new fields you can generate: maiden name, country, suffix, prefix, middle initial. The country list was "borrowed" from somewhere on the web, apologies if it isn't 100% accurate (I believe several of the countries listed no longer exist) but it was as close as I could come to a country list. I actually used Excel's web query feature (manually) for the first time in a long time, to pull the country list into a worksheet. A list of name suffixes and prefixes was hard to find, I just made up a list. Corrections/additions welcome.
4) Post To Twitter
Version 2 of Post To Twitter includes the ability to validate your username and password (without telling you which is incorrect, of course).
You can also expedite your tweeting by creating a text file named "credentials.txt" in the same folder as the add-in. This file should contain your username and password (comma delimited). The add-in will draw your login info from the text file so you do not have to type it in every time! Download the zip file and read the readme.doc for more info.
I realize this isn't the safest way to handle passwords, but it's Twitter, not national security 
If you're not comfortable with keeping your username and password in an unprotected text file on your hard drive, just don't use the text file. You'll continue typing your username and password every time you load the add-in, just like you did before.
I'd also like to remind everyone downloading the add-ins from download.com that the only version of the add-ins available from there are the locked 2003 versions. If you want ANY of the other versions, you need to download them from the Free Excel Add-Ins page.
AddIns ·
Rate This Article:
(No Ratings Yet)
Loading ...What now?
Subscribe To The Blog
Email This Article
Follow Me On Twitter
My Facebook Page
Or just keep reading:
I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space if you want to learn more about VBA. Keep Reading »
Previous Post: Reply to Recipient
Next Post: Renaming files in a folder using VBA
Twitter v3 suggestion: You should allow more characters in your Twitter app, and just post multiple tweats until you've used them all up. Maybe Twitter doesn't allow that, though.
That would be odd — your thoughts broken up across multiple tweets. It is possible, even though there's a limit to the number of API requests you can make per hour.