Macro to open a file that is saved in th same location, but the file name changes with each date

[hg456]

Hi

I have another question for you. I do routine tasks every day which involves opening 3 different files and pasting data into my main file. The data is always in the same format, and the 3 files are saved in the same location (3 different folders through). The 3 files are saved each day and the naming convention is constant, with only the date changing. For example, the files are always saved in C:\My Documents and the files are called test_05.02.2013.xls. Tomorrow the file will be called test_06.02.2013.xls and so on.

So each day I will be rolling a file forward and I want to bring in the info from each of these files based on the new day.

Can someone show me how to do 1, and I will do the others (because the concept will be the same)

Thanks!

 

[patel45]

Sub openTodayFile()
sPath = "C:\My Documents\"
sdate = Format(Date, "dd.mm.yyyy") 
sfile = sPath & "test_" & sdate & ".xls"
Workbooks.Open Filename:=sfile
End Sub