Paste into a QueryTable

[Guest]

I would like to form a SQL query that would Select Where a column value
equals a value in cell A1. I'm trying to write a macro that will copy the
value from the cell and paste it into a Database Query QueryTable box. Is
there an easier way to do this? Can I paste into a QueryBox?

Help is much appreciated. Glenn

 

[Tom Ogilvy]

Just use a parameter query. You can assign the parameter to get its value
from a cell.

See Nick Hodges site for an example:

http://nickhodge.co.uk/gui/datamenu/dataexamples/externaldataexamples.htm

 

[Guest]

Thanks, that worked well. Glenn

Just use a parameter query. You can assign the parameter to get its value
from a cell.

See Nick Hodges site for an example:

http://nickhodge.co.uk/gui/datamenu/dataexamples/externaldataexamples.htm