Add user parameter to Excel ODBC query

I have an SQL script which queries open accounts receivables. I would like to add user paramaters so that the data is refreshed every time the customer number is changed in cell A1. I believe that this can be done through the methods below, but I am not sure which is the best one. [login to view URL] [login to view URL] xl feature [login to view URL] create a recordset ## Deliverables An excel template so that I can add user parameters to all of my sql queries as well as totaling columns (total open AR) and change column headings (query is restricted to one word fields). ## Platform Excel 2002