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

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

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

Multi Workbook Data Extraction
 

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 message
...
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

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 ;)

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 ;)