Posted to microsoft.public.excel.programming

Glenn1203

external usenet poster

Posts: 5

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy/Paste of QueryTable doesn't adjust relative parameters	btait1	Excel Discussion (Misc queries)	1	September 30th 05 06:51 PM
QueryTable with Copy/Paste Functions	Hudel[_2_]	Excel Programming	0	November 17th 03 06:51 PM
Format Problems using Copy/Paste with QueryTable	Hudel	Excel Programming	0	November 17th 03 06:36 PM
Using Copy/Paste and QueryTable Operations	Hudel Holmes	Excel Programming	0	November 17th 03 04:52 PM
Using VBA Copy/Paste and QueryTable	Hudel H	Excel Programming	0	November 17th 03 04:41 PM

All times are GMT +1. The time now is 08:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us