Retrieve the file create date

Giganews Newsgroups
Subject: Retrieve the file create date
Posted by:  AdamBrighton (AdamBrighton.28f4mz_1148652904.2556@excelforum-nospam.com)
Date: Fri, 26 May 2006

Hi
I get a lot of log files created each day that I take into Excel, tweak
the cells and then export to a database.
These file are all created at 00:01 each day and then at the end of the
week emailed to me.
I then create a new column in A and by hand type in the date the file
was created (they have the date in the title) into cell A2, I then have
a macro that copies the date to the rest of the A column depending on
how big the spreadsheet is.

There must be a way of getting the date from either the title or the
date the file was created so I can put the whole thing in a formula, it
would save me a bunch of time and mistakes. I get about 90 per day.

PS. I can't get the date added before they are sent.

Any ideas?

--
AdamBrighton
------------------------------------------------------------------------
AdamBrighton's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34838
View this thread:http://www.excelforum.com/showthread.php?threadid=545856

Replies