Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste into a QueryTable
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste into a QueryTable
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/...taexamples.htm -- Regards, Tom Ogilvy "Glenn1203" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste into a QueryTable
Thanks, that worked well. Glenn
"Tom Ogilvy" wrote: 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/...taexamples.htm -- Regards, Tom Ogilvy "Glenn1203" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy/Paste of QueryTable doesn't adjust relative parameters | Excel Discussion (Misc queries) | |||
QueryTable with Copy/Paste Functions | Excel Programming | |||
Format Problems using Copy/Paste with QueryTable | Excel Programming | |||
Using Copy/Paste and QueryTable Operations | Excel Programming | |||
Using VBA Copy/Paste and QueryTable | Excel Programming |