| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi Workbook Data Extraction
Seasons Greetings!
I have over 1800 workbooks (all the same format created by another application using a template) which sit in a common folder on a server. I now need to trawl through all these extracting specific ranges of data and storing these in a new single workbook-sheet - one row per source workbook. I am familiar with opening and copying data from external workbooks and reading files sequentially in a folder. However is there a way to avoid opening the remote workbook? Each are over 8Mb in size. Thank you -- Regards, Nigel |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multi Workbook Data Extraction
Hi Nigel
You can try ADO http://www.rondebruin.nl/ado.htm I will update the page today for 2007 files and changed the subfolder option -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Nigel" wrote in message ... Seasons Greetings! I have over 1800 workbooks (all the same format created by another application using a template) which sit in a common folder on a server. I now need to trawl through all these extracting specific ranges of data and storing these in a new single workbook-sheet - one row per source workbook. I am familiar with opening and copying data from external workbooks and reading files sequentially in a folder. However is there a way to avoid opening the remote workbook? Each are over 8Mb in size. Thank you -- Regards, Nigel |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multi Workbook Data Extraction
The new page is online now
http://www.rondebruin.nl/ado.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... Hi Nigel You can try ADO http://www.rondebruin.nl/ado.htm I will update the page today for 2007 files and changed the subfolder option -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Nigel" wrote in message ... Seasons Greetings! I have over 1800 workbooks (all the same format created by another application using a template) which sit in a common folder on a server. I now need to trawl through all these extracting specific ranges of data and storing these in a new single workbook-sheet - one row per source workbook. I am familiar with opening and copying data from external workbooks and reading files sequentially in a folder. However is there a way to avoid opening the remote workbook? Each are over 8Mb in size. Thank you -- Regards, Nigel |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multi Workbook Data Extraction
On 23 Gru, 15:09, "Nigel" wrote:
Hi Ron ADO is a great idea, thanks for the examples. I will give it a try and let you know. Seasons Greetings! -- Regards, Nigel "Ron de Bruin" wrote in .. . The new page is online now http://www.rondebruin.nl/ado.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... Hi Nigel You can try ADO http://www.rondebruin.nl/ado.htm I will update the page today for 2007 files and changed the subfolder option -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Nigel" wrote in message ... Seasons Greetings! I have over 1800 workbooks (all the same format created by another application using a template) which sit in a common folder on a server. I now need to trawl through all these extracting specific ranges of data and storing these in a new single workbook-sheet - one row per source workbook. I am familiar with opening and copying data from external workbooks and reading files sequentially in a folder. However is there a way to avoid opening the remote workbook? Each are over 8Mb in size. Thank you -- Regards, Nigel Or you could pull data manually ;) |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multi Workbook Data Extraction
When I next feel suicidal I will consider this option !!!
Cheers :)) -- Regards, Nigel "Coder1215" wrote in message ... On 23 Gru, 15:09, "Nigel" wrote: Hi Ron ADO is a great idea, thanks for the examples. I will give it a try and let you know. Seasons Greetings! -- Regards, Nigel "Ron de Bruin" wrote in .. . The new page is online now http://www.rondebruin.nl/ado.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... Hi Nigel You can try ADO http://www.rondebruin.nl/ado.htm I will update the page today for 2007 files and changed the subfolder option -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Nigel" wrote in message ... Seasons Greetings! I have over 1800 workbooks (all the same format created by another application using a template) which sit in a common folder on a server. I now need to trawl through all these extracting specific ranges of data and storing these in a new single workbook-sheet - one row per source workbook. I am familiar with opening and copying data from external workbooks and reading files sequentially in a folder. However is there a way to avoid opening the remote workbook? Each are over 8Mb in size. Thank you -- Regards, Nigel Or you could pull data manually ;) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex Multi-condition, multi-workbook count | Excel Discussion (Misc queries) | |||
| Multi-Spreadsheet text and data extraction | Excel Programming | |||
| Search & Extraction of Cells in a Workbook without opening it? | Excel Programming | |||
| how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) | |||
| data extraction / cleansing a string column in a workbook | Excel Programming | |||
![Nigel[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
