Hi
to prevent this message try
'...
application.displayalerts=false
activeworkbook.saveas "your_filename"
application.displayalerts=True
'...

--
Regards
Frank Kabel
Frankfurt, Germany


Kathy wrote:
I am trying to save a file (with in a macro) using the below
statement
ActiveWorkbook.SaveAs FileName:="T:\ISBu\IS1\KD2039 FRESH.xls"

but I DO NOT want the user to be prompted with the message - this
file already exist do you wish to overwite yes no cancel (if they
choose no it errors or - I want it to default to YES UNLESS there is
a way that I can verify (and this really has been the entire
problem) - I would like to have the macro VERIFY that they are on the
NETWORK DRIVE 'T' and NOT the local drive 'C' -

is either of these option possible

Thanks you in advance