VB code to "open file" in Excel (Wildcard)

[belstoy]

I am currently trying to write code to open a file in excel that may or may not have a date stamp. Is there a wildcard I can use to open this file whether it is named "Status File" or "Status File 013107". I am currently using the following:
[Workbooks.Open Filename:="C:\My Documents\Status File.xls"]

Please advise,
Belstoy

 

[Andrzejek]

You may want to check if the file exists:

MyFile = Dir("C:\My Documents\Status File*.xls")

and try to open it:

[Workbooks.Open Filename:=MyFile ]

Have fun.

---- Andy

 

[belstoy]

Thanks Andy!
This is perfect.