Check out the info on Ron's site

http://www.rondebruin.nl/ado.htm
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Jules" wrote:

I am trying to consolidate many workbooks...about 250, using ASAP
utility...all of these workbooks contain just a few lines of data...at the
most 40 at the least 1.

I'm wondering if there is a way for me to do this without having to open
them up one by one and hitting disable auto refresh....?

Any help would be appriciated! Happy Happy Day!
--
Jules