Hi All,

I am looking for a vba code to open a workbook containing a particular name.

The file name is dynamic. For eg. The name could be either "Australia_V1" or "Australia_V2".

The code should open and copy the sheet if any part of the filename contains "Australia" in it.

I hope I am clear.

Please help!!!

Thanks and Regards,
Swaminathan N