Thread: Variable for workbook name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Variable for workbook name
OpenBook = ActiveWorkbook.Name
OpenBook = Left(OpenBook,Len(OpenBook)-4)

--
Regards,
Tom Ogilvy

"Mervyn Thomas" wrote in message
...
I'm sure this must be a simple one but I cannot get my stupin brain around
it!
the line of code " Openbook =activeWorkbook.name" returns a string with
the
workbook name including the ".xls". The question is how do I strip out
the
".xls" from the string?




Reply With QuoteReply With Quote