Extracing Data from Unopened workbooks

Hi there,

Lets assume 100 sheets. 99 Data and 1 Master.
Lets assume all cells located in the same subdirectory /test/results

In the master I require an extract (ie results of certain cell refs)
from the 99 data sheets. It can be a one time extraction, ie does not
need to be linked.

Lets say I require Cells b1,c2 and d3 in the master

Is there any VB that I could write that would go to the sheet copy the
data and paste it into the Master sheet
(perhaps even without opening the workbook)

I appreciate any guidance...

Thanks

D



*** Sent via Developersdex http://www.developersdex.com ***

Hi Darin

I have example code here
http://www.rondebruin.nl/tips.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Darin Kramer" <[email protected]> wrote in message news:[email protected]...
>
>
> Hi there,
>
> Lets assume 100 sheets. 99 Data and 1 Master.
> Lets assume all cells located in the same subdirectory /test/results
>
> In the master I require an extract (ie results of certain cell refs)
> from the 99 data sheets. It can be a one time extraction, ie does not
> need to be linked.
>
> Lets say I require Cells b1,c2 and d3 in the master
>
> Is there any VB that I could write that would go to the sheet copy the
> data and paste it into the Master sheet
> (perhaps even without opening the workbook)
>
> I appreciate any guidance...
>
> Thanks
>
> D
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***

Hi Ron,

Looks like a good start ! - I am using the one crate a summary worksheet
from different workbooks.

I need to be able to :
Extract data from MORE THAN One sheet from each of the 99 data files. I
tried to add another sheet name, but it didnt work.

Also I need the results of the each successive extraction to appear on
the same book, not a different one...

Appreciate your help...

Kind Regards

Darin


*** Sent via Developersdex http://www.developersdex.com ***

I think you want run this one on each workbook ?
http://www.rondebruin.nl/summary.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Darin Kramer" <[email protected]> wrote in message news:[email protected]...
>
> Hi Ron,
>
> Looks like a good start ! - I am using the one crate a summary worksheet
> from different workbooks.
>
> I need to be able to :
> Extract data from MORE THAN One sheet from each of the 99 data files. I
> tried to add another sheet name, but it didnt work.
>
> Also I need the results of the each successive extraction to appear on
> the same book, not a different one...
>
> Appreciate your help...
>
> Kind Regards
>
> Darin
>
>
> *** Sent via Developersdex http://www.developersdex.com ***

I could repeat that macro several times - it would work.
Question - I would prefer the data to be added in rows as opposed to
columns ie for it to list name on row a1, then first refe on row a2,
then on a3 (Currently it places results in a1,b1,c1)
Alternatively need a macro to select cells d1 to f1, cut the data and
paste into a2 to c2. Then cuts g1 to i1 and pastes into a3 to c3 etc
etc.... any ideas... ? : )

*** Sent via Developersdex http://www.developersdex.com ***

I will make a example for you

First eat (5:31 here)


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Darin Kramer" <[email protected]> wrote in message news:[email protected]...
>
>
> I could repeat that macro several times - it would work.
> Question - I would prefer the data to be added in rows as opposed to
> columns ie for it to list name on row a1, then first refe on row a2,
> then on a3 (Currently it places results in a1,b1,c1)
> Alternatively need a macro to select cells d1 to f1, cut the data and
> paste into a2 to c2. Then cuts g1 to i1 and pastes into a3 to c3 etc
> etc.... any ideas... ? : )
>
> *** Sent via Developersdex http://www.developersdex.com ***