Hi, I have a WB that contains x number of sheets. There are multiple sheets
that that are called Open (Open1, Open2, etc) and the same for sheets that
are called Closed (we use Excel 2003, limited to 65k rows, tha is why we use
multiple sheets for open and closed transactions). Each sheet has a SecurID
column that is supposed to be unique. I need to run a query that will check
for duplicate SecurID's and give me the ID and # of duplicates. Its a select
union query between Open and Closed. IMPORTANT, the query need to run on the
curent workbook that is in memory and not a saved version of the file on the
network. Also, what type of a ADO connction string would I use to connect to
the current open WB.

Thanks,
Mike