Excel VBA open file with partial name

I am trying to create a macro that will open a file based on the first 4 characters. The remainder of the name is the date which changes every day. The files are always in the same folder.