Save Over

[Lawson]

Hello,

i have written a macro that saves the users file in the
appropriate file on the server when they type the job
name in a certain cell (if they type 23190, is saves to
\\EST-server-1\EST\Quotes\23000\23100\....

i would like to make this faster in the case that the
file already exists and the MS prompt comes up, 'File
found, would you like to save over it?'. i would like my
program to automatically enter yes rather than have user
click yes (or type y)

i know its picky, but it gets annoying after the 100th
time each day.

 

[Norman Jones]

Hi Lawson,

Application.DisplayAlerts = False

'your save code

Application.DisplayAlerts = True

 

[Frank Kabel]

Hi
try

....
application.displayalerts=false
'save code
application.displayalerts=true

 

[Tom Ogilvy]

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