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