Your open statement would be something like
Workbooks.Open Filename:="c:\temp\" & Format(Date, "mm-dd-yyyy") & ".xls"


"Perry" wrote:

Hello,

I'm creating a daily report with certain data.

One of the steps to create this report is the input of certain data
from one Excel file into another. The destination file for this data is
an Excel file which always has a name as follows:

--- Daily_Report_Perry_dd-mm-yyyy.xls

How do I create a macro which always opens the file above with the
"today" date? By example today, wednesday the 9th of November, the
following file should be opened:

--- Daily_Report_Perry_09-11-2005.xls