| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
| sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| validation lists from seperate work books | Excel Discussion (Misc queries) | |||
| Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions | |||
Linear Mode
