From: ch on 26 Jan 2010 00:17
How can we return a workbook's file name with and without extension?
Thanks in advance.
From: Rick Rothstein on 26 Jan 2010 01:55
Is this what you want?
Left(ThisWorkbook.Name, InStrRev(ThisWorkbook.Name, ".") - 1)
Rick (MVP - Excel)
"ch" <ch(a)discussions.microsoft.com> wrote in message
> Hi Tom,
> How can we return a workbook's file name with and without extension?
> Thanks in advance.
Prev: Help with looping in Excel
Next: how can i append data to a sheet or book from another one