I am looking for a method/system defined variable thatstores the \'Filename\' which is displayed in the \'SaveAs\' windows. I need tosave files in a different folder automatically. any code snippet would be agreat help
Do you mean that you want the name that the file already has, so that youcan 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.