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...o&userid=34838
View this thread: http://www.excelforum.com/showthread...hreadid=545856