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.
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.