xljunkie
05-20-2011, 01:17 PM
Bear with me please as this is basic and I'm just starting to learn.
I have 3 workbooks open:
1. Query.xls
2. Macro.xls
3. April.xls
The 3rd one's file name changes from month to month. I want to write code in the Macro workbook that will activate the April workbook.
Is there such a way that I can have a list of months (Jan, Feb, Mar, etc) within the Macro workbook and have code activate the workbook whose first 3 letters are contained in this list? Is there a better way to do it (i.e. have the code activate whatever workbook is not named Query or Macro)?
I have 3 workbooks open:
1. Query.xls
2. Macro.xls
3. April.xls
The 3rd one's file name changes from month to month. I want to write code in the Macro workbook that will activate the April workbook.
Is there such a way that I can have a list of months (Jan, Feb, Mar, etc) within the Macro workbook and have code activate the workbook whose first 3 letters are contained in this list? Is there a better way to do it (i.e. have the code activate whatever workbook is not named Query or Macro)?