use a macro to Open a file with a variable filename

Hi,

I'm pretty new to Macros and VB and I am trying to run a marco that opens a file.

The file name however changes on a daily basis

"Open Position Client Count (Daily)2010-05-24-01-35-27.xls"

I can open the file if the filename contained only the date however I'm stuck with the issue of time, the time is diferent every day.

I have tried to use

Workbooks.Open Filename:= _
"T:\crystal_reports\General\Oracle_Web_Trading_Reports\"Open Position Client Count (Daily)" & Format(Date, "yyyy-mm-dd-HH-MM-SS") & ".xls

But that looks for a file called "Open Position Client Count (Daily)2010-05-24-00-00-00.xls"

Any ideas?

Thanks

Ben