Workbook Variable
 

Typically I would just run through the help menu for this, but our VBA
program at work doesn't have it, so hopefully this is a simple enough
question:

Is there a way to set a variable as the name of the currently open
workbook/file?

Workbook Variable
 

Dim wb As Workbook
Set wb = ActiveWorkbook


wrote:
Typically I would just run through the help menu for this, but our VBA
program at work doesn't have it, so hopefully this is a simple enough
question:

Is there a way to set a variable as the name of the currently open
workbook/file?

Workbook Variable
 

Brilliantly easy, i just didn't have the know-how. Thanks much for the
help.

Andrew Taylor wrote:
Dim wb As Workbook
Set wb = ActiveWorkbook


wrote:
Typically I would just run through the help menu for this, but our VBA
program at work doesn't have it, so hopefully this is a simple enough
question:

Is there a way to set a variable as the name of the currently open
workbook/file?