Thread: Using GetSaveAs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron McCormick[_3_] Ron McCormick[_3_] is offline
external usenet poster
 
Posts: 3
Default Using GetSaveAs

I want users to be able to save a file by prompting them
with a suggested file name but allowing them to overwrite
it with and alternative, but I would also like the usual
Excel prompt to appear The filename Newname already exists
etc, so that they can change their option. I was trying to
use the undernoted code but this does not bring up the
usual alerts. How do I get the alerts to appear?

Application.GetSaveAsFilename Initialfilename:=Newname

TIA
Ron