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