PDA

View Full Version : VBA code to copy and paste a sheet from a workbook containing a particular name.



Swaminathann
08-18-2015, 07:17 AM
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