Save Over
 

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.

Save Over
 

Hi Lawson,

Application.DisplayAlerts = False

'your save code

Application.DisplayAlerts = True


---
Regards,
Norman

"Lawson" wrote in message
...
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.

Save Over
 

Hi
try

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

-----Original Message-----
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.
.

Save Over
 

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

--
Regards,
Tom Ogilvy

"Lawson" wrote in message
...
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.