Global define workbook

[bujaman]

I am trying to globally define the workbook that houses the code as a variable and keep getting an Invalid Outside Procedure Compile Error. Here is my code:

Public SOVComp As Workbook
Set SOVComp = ActiveWorkbook

Any thoughts?

 

[xenou]

Being invalid outside of a procedure one solution would be to put it inside a procedure:

Public SOVComp As Workbook
Sub Foo()
    Set SOVComp = ActiveWorkbook
End Sub

If in the workbook that houses the code you can always use the ThisWorkbook property which is an inbuilt reference to the same.

Sub Bar()
    Debug.Print ThisWorkbook.Name
End Sub