Generate a file name by date....
'To save as current date
ActiveWorkbook.SaveAs "c:\" & Format(Date, "dd-mm-yyyy") & ".xls"
'and for opening previous day's file
Workbooks.Open "c:\" & Format(Date - 1, "dd-mm-yyyy") & ".xls"
If this post helps click Yes
---------------
Jacob Skaria
"mlindsey54" wrote:
What I'm trying to do is to name a file by date and then access that same
file the next day and use the data that's there for current date....
An example is:
All End-totals in file 06/21/09 will be Beginning-totals in currently
opened file that will be named the current date ( 06/22/09 ) at the end of
the day...
In a perfect world I'd like for this file to be automatically named and
saved. But if this can't be done I have no problem doing this my self...
|