VBA Next Workbook If This Workbook is Macro Wookbook

[picton2000]

I require some VBA code so if the person executes the macro while the macro workbook is the active workbook then the macro moves to the next open workbook.

I thought something like the following:

Dim WB As Workbook
For Each WB in Workbooks
If WB Is ThisWorkbook Then Next WB

[YasserKhalil]

Hello
Can you explain more and upload sample of your workbooks so as to get the issue? How many workbooks will be open? Are those workbook with specific names which have specific sequence? What determine the next workbook for you or it is any workbook?

[picton2000]

Hello

There will be two other workbooks open when the macro is executed.
They will not have specific names, they are likely to have different names each time.
No specific sequence is required.
The next workbook can be any other open workbook

[YasserKhalil]

So what will you do with each open workbook?

[YasserKhalil]

As start point you can loop through the open workbooks like that

Please Login or Register  to view this content.

[picton2000]

The two other open workbooks will contain employee payroll data and I will manipulate the data with a macro that is already written.
As the macro is sometimes run by other work colleagues who are not so technical with excel, I want to add some code at the beginning, so the macro moves to any other open workbook, if they start the macro from within the macro workbook itself.

[Norie]

What do you mean by the 'next open' workbook?

[picton2000]

Ok, lets say we have three open workbook files called A, B and C.
A and B are the working files and file C is the macro file.
If the person executing the macro has file C as the active file when the macro starts I want the macro to move to either file A or file B.
I can't refer to exact file names in the macro, because files A and B will have different names each time.

[Norie]

Is the code meant to be run on all open workbooks apart from the 'macro' workbook?

[picton2000]

Hi Norie, yes it would be on all open workbooks.

I am looking for some vba, so when the macro starts, if the user already has file A or file B as the active workbook we are fine. If the user starts the macro with the macro workbook as the active workbook then the code makes workbook A or workbook B the acti e workbook.

So the vba I need is, if we are on workbook A or workbook B do nothing. If we are on workbook C (the macro workbook) then make workbook A or workbook B the active workbook. I don't mind which.