ExcelBanter - New QueryTable?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - New QueryTable? (https://www.excelbanter.com/excel-programming/390973-new-querytable.html)

Neily[_3_]

New QueryTable?

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?

Ron Coderre

New QueryTable?

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

"Neily" wrote:

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?

All times are GMT +1. The time now is 11:47 AM.