Sub Workbookname()
Dim strActivebook As String

strActivebook = ActiveWorkbook.Name

End Sub

--
HTH...

Jim Thomlinson


"Herd" wrote:

I need to get the name of the active workbook assigned to a variable in the
Macro that I am trying to write. Is this possible?

Thanks,