How to: obtain the filename that a module exists in, via VBA?
in [Programming]
|
From: ch on 26 Jan 2010 00:17 Hi Tom, 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? With Extension: ============================= ThisWorkbook.Name Without Extension ============================= Left(ThisWorkbook.Name, InStrRev(ThisWorkbook.Name, ".") - 1) -- Rick (MVP - Excel) "ch" <ch(a)discussions.microsoft.com> wrote in message news:00AC3198-ECC9-41F2-B99C-3EC177BAF601(a)microsoft.com... > Hi Tom, > > How can we return a workbook's file name with and without extension? > > Thanks in advance. >
|
Pages: 1 Prev: Help with looping in Excel Next: how can i append data to a sheet or book from another one |