I have a VBA procedure that performs a query on a database in excel using ADO. If I define the database beforehand using MS Query the procedure works. However, what I'd like to do is define the database object (using a range) in an earlier procedure. If I have a range of cells in Excel that I want to be a database, how do I make this range a database object?
Thanks for the help,
Dave S.
Thanks for the help,
Dave S.