View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paige Paige is offline
external usenet poster
 
Posts: 270
Default Ensuring File Name is Blank

I have the following code that is used to prompt a user to save the current
file:

fname = Application.GetSaveAsFilename(FileFilter:="Microso ft Excel Workbook
(*.xls), *.xls")

However, when the save menu pops up, it has the current name of the file in
the filename slot as a default. I want it to be blank tho, to force the user
to type in name. Does someone know how I can modify the above to do that?