Thread: Help Retrieving filename without .xls attached
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dan E[_3_] Dan E[_3_] is offline
external usenet poster
  
Posts: 53
Default Help Retrieving filename without .xls attached
How about just cutting it down yourself??

Left(ActiveWorkbook.Name, Len(ActiveWorkbook.Name) - 4)

Dan E

"Marshall" wrote in message ...

I would like to try and retrieve the filename of the current workbook,
without having the ".xls" portion of it attached.

I'm currently retrieving the
ActiveWorkbook.Name
maybe there is a way to parse this or something?


Any help is greatly appreciated. Thanks.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/



Reply With QuoteReply With Quote