Consolidating Many Work Books with Little Data
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 |
Consolidating Many Work Books with Little Data
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 |
All times are GMT +1. The time now is 08:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com