View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_2157_] Rick Rothstein \(MVP - VB\)[_2157_] is offline
external usenet poster
 
Posts: 1
Default GetSaveAsFilename - file name is blank

It looks like if you do not provide the FileFilter argument, the InitialFile
argument is ignored. This, of course, is different than with XL2003.

Rick


"JanetJek" wrote in message
...
I have an Excel macro that prompts the user for the file name with
GetSaveAsFilename. It works fine under Window XP (Excel 2000, 2003, 2007)
but with Excel 2007 and Vista, the file name in the prompt box is empty,
blank. There is no file name.

Any suggestions?