VBA Loop Through a File Location

[ryansm05]

Hi,

I've been told that you can use VBA to loop through a file location (example: I:/MyDocs/P7) and return specific cells (example: A2) from every file saved in this location, providing the filename is saved in the correct format.

If anyone has any idea how to do this or a link to a separate topic, it would be a great help.

FYI there could be up to 500 files saved in this location, so hopefully it can process in a reasonable time.

Thanks
Ryan

 

[Excel Planet]

You don’t need to open all files in a folder, use power qery instead.

See below:

https://www.excel-university.com/retrieve-values-from-many-workbooks/