excel 2000, vba and msquery(sql)
 

Is there any way to use additional key words (such as
between and in) when using a macro to pull in external
data? So much extra coding to put arguments in
separately. Thanks.

excel 2000, vba and msquery(sql)
 

pmz

You can use In (and I assume between) in your SQL statement in MSQuery. If
you want to use parameters as the arguments for In or Between, then I don't
think it's possible - at least not that I've seen.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"pmz" wrote in message
...
Is there any way to use additional key words (such as
between and in) when using a macro to pull in external
data? So much extra coding to put arguments in
separately. Thanks.