View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Herd Herd is offline
external usenet poster
 
Posts: 8
Default Workbook Name as Variable



"Jim Thomlinson" wrote:

Sub Workbookname()
Dim strActivebook As String

strActivebook = ActiveWorkbook.Name

End Sub
Thank You for the fast response. It was very helpful.
--
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,