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
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