left(activeworkbook.name,len(activeworkbook.name)-4)
--
Regards,
Tom Ogilvy
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/