Macro problem: Abortion when trying to save on existing filename

  • Thread starter Thread starter Snoopy
  • Start date Start date
S

Snoopy

Hey guys
EXCEL-VBA Problem
When using

ActiveWorkbook.SaveAs Range("x1").Value
ActiveWorkbook.Close

- its ok when the file/filename specified in range X1 not exists, but
if the file allready exist,a standard windows messageboard "Replace
file? "YES" "NO" "EXIT appears.
When I choose "YES" the macro works and the file is replaced.
When I choose "NO" or "EXIT" my macro crashes.
How can I make my macro by-pass this and just abort whithout crashing?

Hopefully regards
Snoopy
 
Hi Snoopy

If you always want to overwrite use

Application.DisplayAlerts = False
'Save code
Application.DisplayAlerts = True

If you want to use the No option test if the file exist with Dir and do what you want

If Dir("Filepathname") <> "" Then
 
Hi Snoopy

If you always want to overwrite use

Application.DisplayAlerts = False
'Save code
Application.DisplayAlerts = True

If you want to use the No option test if the file exist with Dir and do what you want

  If Dir("Filepathname") <> "" Then

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm








– Vis sitert tekst –
Click to expand...

Thanks a lot Ron :)
Regards
Snoopy
 
Back
Top