Macro problem

P

puiuluipui

Hi, i have a macro that save an excel file, but i have another workbook in
the same folder. i need to replace that file.
I need the macro to ignore the message that ask me if i really want to
replace existing file.

Can this be done?
Thanks!
 
F

FSt1

hi
at the beginning of your code add this...
application.displayalert = false
this turns off all display messages.
then at then end of your code add this.
application.displayalerts = true
this turns them back on again.

regards
FSt1
 
G

Gord Dibben

Application.displayalerts = false

your code to save

Application.displayalerts = true


Gord Dibben MS Excel MVP
 
P

puiuluipui

Thanks!

"FSt1" a scris:
hi
at the beginning of your code add this...
application.displayalert = false
this turns off all display messages.
then at then end of your code add this.
application.displayalerts = true
this turns them back on again.

regards
FSt1
Click to expand...
 
Top