Excel Function/Code to See if Workbook is Open and activate based on a cell value

I am trying to find a code to help me check if a particular workbook is open using a value from a cell that has a v-lookup in it. If the workbook is open, I want to activate it , and add a sheet to the workbook. If the workbook is not open, I would like to create one.

The code below only works when the workbook is not open.

The problem I am having is that, when the particular workbook is open – the Function is not finding it, and always creating a new workbook.

I am using a function “WorkbookOpen” to check if the workbook is open.
The cell value is  NewName = Range("B7").Value
B7 Contains a V-lookup.


Can someone please assist?

Code below:

Please Login or Register  to view this content.

If your code fails to find the workbooks even after they've created them once, then your syntax in the macro isn't taking into account your text strings properly.

What exactly is in B7 and B8?