New QueryTable?

G

Guest

Does anyone know how to use VB to create a QueryTable on a blank sheet?

The only way I'm able to create one is by using Data/Import External Data
command and querying a database.

Any ideas?
 
G

Guest

Did you check VBA help for "QueryTables"?
Under Methods, select ADD and see the examples for QueryTables.

Does that help?

Post back with more questions.

***********
Regards,
Ron

XL2002, WinXP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question on Deleting Querytables 3
help to understand 'querytable' 1
Connecting Questions on Querytables 1
Need Help with Refreshing Querytables. 8
listobjects and querytables 0
how delete old querytables? 2
call multiple macros in workbook_open? 6
Reset QueryTable error on empty text file 0

Top