Declaring workbook variables and setting variables to "not" other workbooks VBA

[SBF12345]

Greetings,

Dim wb1 As WorkbookDim wb2 As Workbook
Dim wb3 As Workbook
Dim wb4 As Workbook


Set wb1 = General_Account_Ledger.xls
Set wb2 = PERSONAL.xls
Set wb3 = Products.xls
Set wb4 = wb1 Or wb2 Or wb3

I would like to write a subroutine that operates while four different workbooks are open. The fourth workbook will change regularly but will need to work with other open workbooks. I have set different variables for the four workbook, but am stumped as to how to set the fourth. Ideally, if it was possible I would set wb4 to something like

set wb4 <> wb1 Or wb2 or wb3

but its not possible to write it like this. I suspect that defining a random name sheet with a single variable will be done using "not-equal to"

Any suggestions with the logic would be greatly appreciated.

 

[JoeMo]

If the 4th workbook is the active workbook when the subroutine is initiated then:

set wb4 = Activeworkbook

 

[SBF12345]

I should be able to run the sub with the wb4 open so that it is the activeworkbook at the time the sub is run. let me try this...

 

[SBF12345]

OK, it seems to be working, but I have another problem with the code on a different subject. the beginning of the script looks like this now

Dim wb1 As WorkbookDim wb4 As Workbook


Set wb1 = Application.Workbooks("General_Account_Ledger.xls")
Set wb4 = ActiveWorkbook

the activeworkbook will need to be open when the variable is set

 

[JoeMo]

OK, it seems to be working, but I have another problem with the code on a different subject. the beginning of the script looks like this now

Dim wb1 As WorkbookDim wb4 As Workbook


Set wb1 = Application.Workbooks("General_Account_Ledger.xls")
Set wb4 = ActiveWorkbook

the activeworkbook will need to be open when the variable is set

A work book cannot be the active workbook unless it is open.

 

[SBF12345]

the workbook, wb4, is on screen when I run the macro which should be OK as long as I remember to keep it as the on screen/open book

 

[JoeMo]

the workbook, wb4, is on screen when I run the macro which should be OK as long as I remember to keep it as the on screen/open book

Aka - the Activeworkbook

 

[SBF12345]

totally!