Passing a workbook name to a variable

[Mollethewizard]

Probably this is very simple but I haven’t found the solution.

Is there a way to pass a workbook name to a variable? It would be most helpful if the variable could be used in different modules within a project. The variable is to be used like “name.activate” , name.close savechanges = no etc.


Mollethewizard

 

[Bogiemon]

You can assign it to a variable as:

Dim w As Workbook
Set w = Application.ActiveWorkbook

and you can reference w instead of activeworkbook.

You can put the Dim statement in the Declarations but not the Set. This way you will need to Set the variable once in each module.

Bogiemon

 

[Mollethewizard]

Thanks a million! Works like a dream!

Mollethewizard