Open changing name files with macro

[g4getmoney]

Hello everyone,

I'm creating a spreadsheet at work and ran into an issue I'm hoping to get some help with:

I have a few columns, A,B,C which I would like to populate with new numbers and dates on a daily basis.

I wanted to accomplish this using a macro that would:

My question is how to:
1) open a workbook with the date as it's title (i.e. 072710.xls) which will change continuously
Question: How do I look for a file who's title will increment in a date format?

Any assistance would be greatly appreciated,
thanks guys, this forum is fantastic!

[Domski]

Somethink like this:

Workbooks.Open "H:\" & Format(Date, "mmddyy") & ".xls"

Will open the workbook for today's date.

Dom

[g4getmoney]

Worked like a charm, thank you.

Somethink like this:

Workbooks.Open "H:\" & Format(Date, "mmddyy") & ".xls"

Will open the workbook for today's date.

Dom