Macro problem

[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!

 

[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

 

[Gord Dibben]

Application.displayalerts = false

your code to save

Application.displayalerts = true


Gord Dibben MS Excel MVP

 

[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

 

[puiuluipui]

Thanks!

"Gord Dibben" a scris:

Application.displayalerts = false

your code to save

Application.displayalerts = true


Gord Dibben MS Excel MVP




.