Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a macro where i want to save a file but there is an existing file with
that name already. how can i keep the dialog box from popping up and asking if i want to save it. i have tried the following code but it doesnt work. Thanks. ActiveWorkbook.SaveAs Filename:= _ "\\Houston\manfdocs\Macros\RepairImporttest.xl s", FileFormat _ :=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:= _ False, CreateBackup:=False, AccessMode:=xlNoChange, ConflictResolution:=xlLocalSessionChanges |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Choosing no when asked to overwrite an existing file? | Excel Programming | |||
Rename rather than overwrite existing file | Excel Programming | |||
Create a new file, name it and overwrite an existing name without confimation | Excel Programming | |||
Overwrite existing file without prompt | Excel Programming | |||
Overwrite existing file without prompt | Excel Programming |