Got any resources on ADO and recordssets? I'm not familiar with
this...

You can download an example kit from Rob Bovey's website that explains
everything you need to know about using ADO with Excell workbooks.

http://www.appspro.com/conference/Da...rogramming.zip

It's written for Excel2003 and earlier so if you need to code for
Excel2007 and later then just substitute the using the Jet.4.0 provider
with the Ace.12.0 provider. Likewise, substitute using Excel 8.0 in
ExtendedProperties with Excel 12.0.

Example:
for Excel 11 and earlier:
"Provider=Microsoft.Jet.OLEDB.4.0;"
"ExtendedProperties=Excel 8.0;"

for Excel 12 and later:
"Provider=Microsoft.Ace.OLEDB.12.0;"
"ExtendedProperties=Excel 12.0;"

Note that to use ADO with Excel workbooks you don't need to open the
file in Excel. Not sure if this is what you want but just offered it as
an alternative suggestion as it would allow you to put your code in a
separate file (XLA for example) so the data file[s] can be just a
normal XLS without code.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc