Hi, I am trying to write a code to switch between 2 workbooks. Should be easy with the Workbook.Activate. The problem is: the name of one of the workbook is not always the same (it is data that are imported from another application, and there is a number always added to the name e.g. "Exported Data [1].xls", "Exported Data [3].xls" even though it is the same data that is imported. I had Workbook ("Exported Data [1]"). Activate, but since the number inside [] would change, I get and error when running the code, if the number is not [1]. Any suggestion how to get around?
Thank you for your help.
Bookmarks