i am trying to write some vba code to copy 200 workbooks from 200 folders on a network.
example i have a directory called F
Within F i have staffstreamA
within STAFFSTREAMA i have 200 folders named as forth A1,A2,A3 ETC TO A200
Within folders A1 is a folder called SALES
within the SALES folder is a WORKBOOK called SALESDATA
SO REFERENCE TO THE WORKBOOK IS F:\STAFFSTREAMA\A1\SALES\SALESDATA_A1.XLS
I HAVE 200 OF THESE WHICH GO FROM A1 TO A200, folders with THE SAME named FOLDER CALLED SALES and same workbook called salesdata_A1 ETC.
I need to be able to go through each folder eg A1,A2 ETC OPEN THE protected workbook select a cell range from a specified worksheet eg JANSALES and copy the data to one worksheet on my local drive.
please help, thanks a billion.