naveencn023 wrote:

I have the folder( sub folders) keywords in column A and the folder
paths in column B. I need to macro to search the folder with the keyword
in the path and it should throws message "PASS" if folder exists or
"FAIL" if folder doesn't exists in column C. Also if folder exists, it
should show last modified date in column D.

Please do the needful.

Thanks in advance for your help..

Did you try to do it yourself? If so, post what you've already got, so we can
give you some pointers.

If not, I'll do it for you, US$1000, paid in advance, no refunds.

--
You'd have better luck trying to artificially inseminate a brick.