MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Filename variable

  Asked By: Ashan    Date: Oct 27    Category: MS Office    Views: 707

I am looking for a method/system defined  variable that
stores the \'Filename\' which is displayed in the \'SaveAs\' windows. I need to
save files in a different folder automatically. any code snippet would be a
great help



1 Answer Found

Answer #1    Answered By: Sam Anderson     Answered 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.

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