Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
User replaces existing file with blank during file open | Excel Discussion (Misc queries) | |||
Macro to combine worksheets data - overwrites existing | Excel Discussion (Misc queries) | |||
Worksheets.add in VBScript overwrites existing worksheet | Excel Worksheet Functions | |||
Importing text file, only option to edit existing file | Excel Discussion (Misc queries) | |||
File save location with Application.GetSaveAsFilename | Excel Programming |