To remove the promt question message in a Save As method
 

Hi all, i wish to remove the prompt question message when i use the save as
method because the file already exist and i know i could replace it.

regards

Greg

To remove the promt question message in a Save As method
 

sorry useless message.

"sharpegreg" wrote:

Hi all, i wish to remove the prompt question message when i use the save as
method because the file already exist and i know i could replace it.

regards

Greg

To remove the promt question message in a Save As method
 

Application.DisplayAlerts = False
ActiveWorkbook.SaveAs ...........
Application.DisplayAlerts = True

If this post helps click Yes
---------------
Jacob Skaria


"sharpegreg" wrote:

Hi all, i wish to remove the prompt question message when i use the save as
method because the file already exist and i know i could replace it.

regards

Greg