View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default GetSaveAsFilename alwyas overwrites existing file

I am exporting a text file from within my macro, but it ALWAYS overwrites an
existing file without asking me if I want to replace it?

Anybody know what I did wrong?

FName = Application.GetSaveAsFilename("Rename_me.gft", filefilter:="GIFT
files _
(*.gft), *.gft,Text files, *.txt,All Files, *.*", _
Title:="Please pick a file name for your GIFT file")
If FName = False Then
myMessage = "You didn't select a file." & Chr(10) & Chr(10) & "Export
has been ABORTED!"
GoTo MyError:
End If

THanks