LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default modified date of the file

HI,

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..
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting file name and Modified date MarkS Excel Programming 2 September 14th 07 10:08 PM
date file modified Matthew Excel Discussion (Misc queries) 2 October 11th 06 06:52 PM
Get the date a file was modified JustinP Excel Programming 2 September 5th 06 04:54 AM
Set a file's modified date? Ken Loomis Excel Programming 1 July 1st 05 01:50 AM
File's last modified date Josh Sale Excel Programming 2 January 12th 04 09:42 PM


All times are GMT +1. The time now is 01:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"