My World A Blog On All The Things That Happen In My Life

Chudi pooja at homeDSC02176DSC02178DSC02181DSC02182DSC02183DSC02184DSC02186
Status » Grid 2 gameplay video - Faceoff run with the Nissan Fairlady Z: http://t.co/IiAPdIA9sS via @YouTube

Posts tagged Excel

Creating and Editing Parameterized Queries in Excel 2007
on 12/10/2010 - like it?

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 – now that’s something totally different. I searched around a bit for documentation on doing so – and found that any articles on the same were woefully inadequate. To be specific: There are plenty of articles on how to change the parameters – just head over to Properties -> Query Definition -> Parameters. Ok, cool. Now hang on, the Parameters button is disabled. How the heck am I supposed to get it enabled ? I had a ball of a time trying to figure out a way to do it – and in the end, found the answer, and posted it. Figured might as well post it here for my reference… and for others who are searching for a way to do the same.

(more…)

Tags: , , , , ,