Macro To Look at list of files in column "A" and show their last Saved Date in Column "B"

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

Originally Posted by Trebor76

Hi drknot,

Post the "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" code and I'll try and convert it for you.

Robert

Thanks for the offer of help Robert

here it is

"MsgBox CreateObject("Scripting.FileSystemObject").GetFile("c:\folder\Filename.xls").DateLastModified"

Cheers
Again

Originally Posted by Trebor76

You're welcome

Try this:

Please Login or Register  to view this content.

Regards,

Robert

Robert - many thanks, it works a charm, and you've made it look so simple.

cheers again
drknot