Thanks a lot for your response.. but i am new to macro and i am not getting what you explained.

So kindly provide us the code for the example mentioned below, so that it will be helpful for us..

Path File keyword file present/ file nor present last modified date
G:\Park Infra IND
F:\SEEMA Data Dec

Thanks a lot in advance..