Hi all,

Just a small matter in that I want to select a workbook in order for a macro
in another workbook to collect the necessary variables. The name of the file
will change month on month but will always start with "COM". I guessing that
wildcards will be needed in a code to select a workbook with "COM" in it's
title but can anyone provide tha code? I need this to try and limit as much
as possible user input to run the macro

Many thanks