Retrive data from closed workbooks

Hi All,

Hope all of you are doing great..

I have some worksheets at office which falls at certain network shared folder ... users used to daily update the data into those workbook, I was thinking for the ways to get the data into one consolidated sheet daily without opening it ..

so can anyone please tell me the method how to access a closed workbook and get data from it ..

I have a piece of snippet which I got from this forum .. but problem with that is all the master and user sheet must be in same location any how I am pasting down that snippet

Please Login or Register  to view this content.

http://www.rondebruin.nl/copy3.htm