Hi
ActiveWorkbook.SaveAs newfilename
If newfilename already exists at the saving location, a prompt will pop up
to confirm overwrite. Can I say Yes through the codes instead of manually
clicking on the Yes button ?
Thanks
Steve
Hi
ActiveWorkbook.SaveAs newfilename
If newfilename already exists at the saving location, a prompt will pop up
to confirm overwrite. Can I say Yes through the codes instead of manually
clicking on the Yes button ?
Thanks
Steve
Application.DisplayAlerts = False
.... code
Application.DisplayAlerts = True
--
HTH
RP
(remove nothere from the email address if mailing direct)
"SP" <none> wrote in message news:[email protected]...
> Hi
>
> ActiveWorkbook.SaveAs newfilename
>
> If newfilename already exists at the saving location, a prompt will pop up
> to confirm overwrite. Can I say Yes through the codes instead of manually
> clicking on the Yes button ?
>
> Thanks
> Steve
>
>
Thank you...cool.
Steve
"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> Application.DisplayAlerts = False
> ... code
> Application.DisplayAlerts = True
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "SP" <none> wrote in message news:[email protected]...
>> Hi
>>
>> ActiveWorkbook.SaveAs newfilename
>>
>> If newfilename already exists at the saving location, a prompt will pop
>> up
>> to confirm overwrite. Can I say Yes through the codes instead of
>> manually
>> clicking on the Yes button ?
>>
>> Thanks
>> Steve
>>
>>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks