PDA

View Full Version : macro to find modified date of file



naveencn023
04-10-2014, 01:50 AM
Hi,

I need a macro for the below condition.

I have "n" folder paths in column A, file keywords in column B.

Macro should search for the file with keywords and return "file exists" or "file doesn't exists" message in column C and if file exists it should return the last modified date and time of the file in column D, if file doesn't exists it should be blank.

Thanks in advance for your help.

mancubus
04-10-2014, 04:45 AM
welcome to the forum.

check this:
http://excelexperts.com/vba-tips-list-files-in-a-folder

scroll down the page to see the downloadable file.