Hi,

Wondering if anyone can advise how to query a named range within an excel
spreadsheet. ie rather than query an external datasource I would like to have
a table in excel that is named by a range and then query the range using
criteria to return a sub set of records. I would prefer not to do this using
pivot tables, unless there is a way to turn off the GUI interface to pivot
tables.

Thanks

--
David Wright

You can use the ADO Excel driver. Plenty of examples if you google this
newsgroup or the web.

Tim

--
Tim Williams
Palo Alto, CA


"David Wright" wrote in message
...
Hi,

Wondering if anyone can advise how to query a named range within an excel
spreadsheet. ie rather than query an external datasource I would like to
have
a table in excel that is named by a range and then query the range using
criteria to return a sub set of records. I would prefer not to do this
using
pivot tables, unless there is a way to turn off the GUI interface to pivot
tables.

Thanks

--
David Wright

Tim, Thanks for your reply which was very helpful which together with
together with Tom's help has got me on my way.
--
David Wright


"Tim Williams" wrote:

You can use the ADO Excel driver. Plenty of examples if you google this
newsgroup or the web.

Tim

--
Tim Williams
Palo Alto, CA


"David Wright" wrote in message
...
Hi,

Wondering if anyone can advise how to query a named range within an excel
spreadsheet. ie rather than query an external datasource I would like to
have
a table in excel that is named by a range and then query the range using
criteria to return a sub set of records. I would prefer not to do this
using
pivot tables, unless there is a way to turn off the GUI interface to pivot
tables.

Thanks

--
David Wright

Just in case you are not awa
If you do it with code, there is no GUI interface.

--
Regards,
Tom Ogilvy


"David Wright" wrote in message
...
Hi,

Wondering if anyone can advise how to query a named range within an excel
spreadsheet. ie rather than query an external datasource I would like to
have
a table in excel that is named by a range and then query the range using
criteria to return a sub set of records. I would prefer not to do this
using
pivot tables, unless there is a way to turn off the GUI interface to pivot
tables.

Thanks

--
David Wright

Tom, Thanks for your reply which was very helpful which together with
together with Tim's help has got me on my way.

--
David Wright


"Tom Ogilvy" wrote:

Just in case you are not awa
If you do it with code, there is no GUI interface.

--
Regards,
Tom Ogilvy


"David Wright" wrote in message
...
Hi,

Wondering if anyone can advise how to query a named range within an excel
spreadsheet. ie rather than query an external datasource I would like to
have
a table in excel that is named by a range and then query the range using
criteria to return a sub set of records. I would prefer not to do this
using
pivot tables, unless there is a way to turn off the GUI interface to pivot
tables.

Thanks

--
David Wright

also, you can fetch a subset of records (even of fields) using the Advanced
Filter. (manual or a single command in code).

Debra Dalgleish
http://www.contextures.com/tiptech.html

Look under A

--
Regards,
Tom Ogilvy


"David Wright" wrote in message
...
Hi,

Wondering if anyone can advise how to query a named range within an excel
spreadsheet. ie rather than query an external datasource I would like to
have
a table in excel that is named by a range and then query the range using
criteria to return a sub set of records. I would prefer not to do this
using
pivot tables, unless there is a way to turn off the GUI interface to pivot
tables.

Thanks

--
David Wright