Programmatically pass query params
Trying to run a query several times, each time with a new parameter. The
query can be easily refresh by selecting the cell and background refreshing
the query, as I found by recording a new macro. The macro record does not
capture the change to the cell that contains the param.
Any ideas?
THanx.
|