Good Morning All

I have some excel files that are updated and saved automatically overnight. - About 50 of them, in a dozen different locations.

Is it possible to have a macro go through all the locations in column A and return their last saved date / time in column B in order to save me checking files individually?

I did find some code on the web, but it wasn't really suitable as it was for one file only and only showed the answer in a message box.

Many thanks in advance for any help, as you can see I'm quite inexperienced in this.

Cheers

Drknot