Loop through Subfolders: Copy/Paste Cell Data

[Fretflyer]

Can someone get me pointed in the right direction on creating vba to loop through folders and subfolders to copy/paste data from a specific cell in multi-worksheet workbooks?

The cell is in the same place in all workbooks and is a named range/cell (jobnumber).
The workbooks have a standard ascending file name (C10, C11, C12 etc..) but each file is in a seperate folder, a few levels deep in the server directory.

Example directories
//server/jobs/c10/c10workbook
//server/jobs/c11/c11workbook

I hope that makes sense. Any help at all is much appreciated.

 

[Fretflyer]

Would the add-in need to be installed on any computer that uses it? Are there any security/permissions or anything that would need to be changed or set on each computer to allow it to work?

 

[Ron de Bruin]

Yes it must installed on each computer

The good news is that the add-in will work also if the security settings is set to high,
If it is set to high a workbook with code will not work but the add-in is working.