Windows Wildcard Activate

[Pierce Quality]

Hi All, I have an issue with the Windows.Activate property.
I have a macro that vertically splits the view into two windows for the user, and the problem is the specific workbook reference in the syntax.
Here is what I have so far:

Please Login or Register  to view this content.

The name of this workbook will change and therfore throw up a reference error, so I was wondering if someone could point me in the right direction. I can't quite figure out how to reference wb1 in the Windows.Activate property.

Thanks!

[pjwhitfield]

If you open them in a specific order them reference the Index property.

Please Login or Register  to view this content.

[Pierce Quality]

Thanks pj, thats a good suggestion, but the end user will already have at least one other workbook open before the macro is ran, so the Index number would be variable.

Thanks

[Pierce Quality]

Update:
Haven't come across a solution so far, so in the meantime I've added a bit of code to exit the sub if the workbook name is changed:

Please Login or Register  to view this content.

Hopefully a solution is possible, but if not, this way there won't be any errors.

[Pierce Quality]

Bumping along.

[Pierce Quality]

Update: Ended up finding a solution by using the windows index number. This also solves the problem of having multiple workbooks open, as it will exit the sub if that condition exists

Please Login or Register  to view this content.

Marking this as solved.
Thanks