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 ***