How to set your active workbook to a variable

[Darthzo]

Hello I am getting an error when I try to set a variable to the active workbook can someone please explain why this error was generated.

Below is the syntax I used Thank you

Sub SetupTransfers()
Dim MyBook As Workbook
MyBook = ActiveWorkbook.Name
end sub

[HaHoBe]

Hi, Darthzo,

try it this way:

Please Login or Register  to view this content.

Ciao,
Holger

[Norie]

Try this.

Please Login or Register  to view this content.

[Darthzo]

Thank you Norie and HaHoBe it worked!