Get the value to a variable and use that within your query.

Dim varTemp as variant

varTemp = Workbooks("<bookname").Sheets("Interface").Range( "B5")

If this post helps click Yes
---------------
Jacob Skaria


"Joseph Atie" wrote:

Is there a way to use a cells from an excel sheet as a parameter in an ms
query editor query?

i assume i could do it using vba by changing the query before i run the script

is there a better way / a way to do it from ms query.

I tried using a cell reference but ms query would not accept it

i.e =Interface!B5

Thanks in advance

Joseph Atie