I spotted this question on Super User about creating parameterized queries in Excel 2007 and attempted to answer it - as I thought it would be pretty easy.
And well - it was easy - the part part where you create the query, that is. Now creating parameterized queries -