Parameter Query in MS Excel

[wotrac]

Hi Folks

I am trying to create an MS excel Query which uses the cell references
in an Excel Spreadsheet.
I have no problem running the parameter query with 1 or 2 cells, but my
source spreadsheet will have a variable range of cells, greater than
30.

Could anyone tell me if there is a way to pass these cell references to
the MS query automatically, so that when the spreadsheet refreshes, the
data will be updated.

N.B. My VBA is limited

 

[Don Guillett]

You would need to tell us more such as the url being used and what method of
query you are using and the part of the url that needs to be changed.