Activating unsaved open workbook using "if "name" like "name" satement

**joshuarobbins** · 05-22-2015, 10:45 AM

Hello everyone,

Eevry day I have to run a report that brings up a Workbook with a dynamic title. However, the title always contains "Course Flags Live" within it. I am trying to create a macro that will activate this workbook if it contains this text, so then I may create my other workbooks based off of this master report. Below is the code I have so far, and the "If, Then" statement is bolded. I am stumped on why it is not working. Any help would be greatly appreciated.

Please Login or Register  to view this content.

**TMS** · 05-22-2015, 11:17 AM

You have define a variable, wb, to refer to a workbook. However, you have not set it to refer to any workbook ... so wb.name will be empty/blank.

You have added two new workbooks so (by defaukt) they will be Bookn and Bookn+1, for example, Book3 and Book4.

You have not created a reference to either of those workbooks either.

Regards, TMS