Hi all,

I am importing excels into code via an adodb connection, but have ru
into the problem of many of the excels not having standard sheet name
(ie- "import" instead of "Sheet1"). Is there a way to do a SELEC
query without knowing the name of the sheet? This is furthe
complicated by the workbooks potentially having two sheets rather tha
just one, again with an unknown name.

A method that iterates through the sheets sequentially would b
terrific.

Thanks in advance,
M

--
Message posted from http://www.ExcelForum.com