Add-in Updates

There are several Excel add-in updates available. Mozy on over to the 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.

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 :P 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.

About JP

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 to learn more about VBA. Keep Reading »


Related Articles:


Share This Article:

Share and bookmark this articledelicious buttonfacebook buttonlinkedin buttonstumbleupon buttontwitter button

comment bubble 2 Comment(s) on Add-in Updates:

  1. 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.

This article is closed to new comments. Why?
excel school learn dashboards