SQL with Excel ranges

A

Arshavir Grigorian

Hi,

I would like to be able to select a set of Excel cells, name them,
then write VBA code to filter the range based on certain criteria -
essentially treat the range as a database table and run an SQL on it
returning a set of rows that match the criteria (the SQL WHERE
clause). Is it possible to do such a thing and if so how should I go
about coding it? DAO? I think I can simply loop through the range and
filter rows through an IF() statement, but I am thinking there is a
better way ...

Thanks.
 

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

Need Help with a VBA subroutine 0
On Double Click - Filter Transactions to New WorkSheet 0
filter that yeilds no results 6
VBA Filtered Pivot Table Showing "Multiple Values Selected"; Only One Value Selected 0
Page numbering with Merged Document and IF statements 1
Macro needs updated Range name addresses 3
Question about a range 9
Embedding excel formula in MS Query that will be evaluated in excelnot in the SQL server 0

Top