Prev: Taking w/sheets out of a workbook
Next: Rounding up
From: puiuluipui on 18 May 2010 17:09
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!
From: FSt1 on 18 May 2010 17:32
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" wrote:

> 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!
From: Gord Dibben on 18 May 2010 17:40
Application.displayalerts = false

your code to save

Application.displayalerts = true


Gord Dibben MS Excel MVP


On Tue, 18 May 2010 14:09:01 -0700, puiuluipui
<puiuluipui(a)discussions.microsoft.com> wrote:

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

From: puiuluipui on 19 May 2010 01:56
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" wrote:
>
> > 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!
 | 
Pages: 1
Prev: Taking w/sheets out of a workbook
Next: Rounding up