Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Ashan Kaya   on Oct 27 In MS Office Category.

  
Question Answered By: Sam Anderson   on Oct 27

Do you mean that you want the name that the file already has, so that you
can use that name with a different directory path?

I think ThisWorkbook.Name will give you what you want.

ThisWorkbook.Path is the directory; ThisWorkbook.FullName is the lot.

Share: 

 
 
Didn't find what you were looking for? Find more on Filename variable Or get search suggestion and latest updates.


Tagged: