Query variant/

[Chas17]

I query an excel file from an excel file, part of the code reads:

"WHERE (`List$`.LAST Like 'we%')")

the we% is searching for names in cells that begin with we.

How do I rewrite "WHERE (`List$`.LAST Like 'we%')")

to instaed of using 'we%' it uses Range("a1")

thanks,
Chas

 

[Cbrine]

Chas,
This should do it.
"WHERE (`List$`.LAST Like '" & range("A1") & "%')")


HTH
Cal

 

[Chas17]

Yes, Thank you very much, works great.

How did you know where to put the "s,

seems like I tried them all...

Thanks.

 

[Cbrine]

Years of building on the fly formula's to add to worksheets. You need to build them in a string format, like a SQL statement.



Cal

 

[Chas17]

Thanks!