I'm trying to create a macro to open a sheet in a file but I only know part of the workbook name i.e the file is called comparisonxxxxxx xxxx is it possible to use a wildcard search for the rest of name so I can select the workbooks sheet.

I'm looking for a way to do somthing like this

Windows("comparison"*" & "*".xls").Activate
Sheets("Price Exception").Select

has any one got any ideas on how to do this thanks!