I have a code that opens a workbook with the name "CashVariance"
concatenated with the effective audit date, formatted as "mmddyy".
Therefore, if the audit date is 7/18/06, the file named
CashVariance071806.xls will open.

An upgrade to Crystal Reports saves the file as CashVariance &
"yyyy-mm-dd-hh-mm-ss".xls. The time is variable. Is there a way to modify my
code to open the file by looking only at the "yyyy-mm-dd" and ignoring the
"-hh-mm-ss"? I don't know how to utilize the left function in a file name or
use wildcards in the Workbooks.Open procedure.

Any help would be greatly appreciated.

Sam