how do I open other workbooks in excel using wildcards
 

I am trying to open other workbooks that have a date and time stamp applied
to the file name but they also contain a common word as well. In this
instance Queue. What I would like to know is can some code be writen in excel
vba that ignores the first part of the file name and focus's on the Queue
word and opens the file?

how do I open other workbooks in excel using wildcards
 

Have a look at GetOpenFilename in VBA Help!
Regards,
Stefi

€žKiwijohn007€� ezt Ã*rta:

I am trying to open other workbooks that have a date and time stamp applied
to the file name but they also contain a common word as well. In this
instance Queue. What I would like to know is can some code be writen in excel
vba that ignores the first part of the file name and focus's on the Queue
word and opens the file?