I don't see how ADO could do autofill; ADO is not a worksheet modification
tool. ADO can definitely extract data from a closed workbook, and though I
have little experience, it is my impression that it can also store data in a
closed workbook. You might be able to use VBA in conjunction with ADO to (a)
calculate the values that need to be filled in and modify the related
records, or (b) delete the appropriate records.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"ytayta555" wrote in message
...
On 21 Mar, 15:25, "Don Guillett" wrote:
Sounds like it might be easier to just open the workbook

Thanks again

I have now 231 workbooks and the number can became
bigger ; I find that in ADO you can work with SQL querrys;
maybe SQL can do this actions (autofill and delete) in my
database ;I am looking for (...normaly..) speed .I just read in
an Mark's link that ADO can to write data in a database , too ;
maybe I'll find how to do and this 2 actions (if it is posible ),
autofill and delete .