Get Date Modified Details [Archive]

View Full Version : Get Date Modified Details

asingh

04-20-2006, 08:13 AM

Hi,
I have a Access data base to which I have linked some tables. They are all [.mdb + .txt + .csv + .xls files] present in one folder on my D: drive. Is it possible to get the names/paths/and date modified details of these files. I know access has a functionality "CurrentProject.Connection" which tells the access data base..the current location of the data base [this is also where all my link table files are present]. Is there any way this can be used [or any other method] that will give me the names/paths/and date details of the linked files. Thanks a lot...

regards,

ASingh

stanl

04-20-2006, 09:14 AM

You could use either WMI or the DSO.dll.

Stan

asingh

04-20-2006, 09:52 AM

Hi Stan,
I am not too sure how to use the above to mentioned...Pls could you tell me a bit more...thanks

Asingh

stanl

04-20-2006, 03:04 PM

http://support.microsoft.com/?id=224351#E03D0ADAAA

has DSO information and sample code. That will handle Office or OLE documents [which leaves .csv files out]. I think WMI code has been previously posted, but here is a good link

http://www.winguides.com/forums/showflat.php?Cat=&Board=brdScripting&Number=100392&page=3&view=expanded&sb=3&part=

Stan