Workbook Variable

[[email protected]]

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?

[Andrew Taylor]

Dim wb As Workbook
Set wb = ActiveWorkbook


[email protected] 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?

[[email protected]]

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
>
>
> [email protected] 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?