how to save shared file

[Patrick]

I have a macro which manipulates data in shared files


When it starts it has to make the files unshared first
so at the end it uses

ActiveWorkbook.SaveAs Filename:=ActiveWorkbook.FullName, _
accessMode:=xlShared

to save them as shared again

This gives a prompt 'File already exists'
How can I avoid this prompt and force it to resave over the existing file?


(should i delete the file first - if so how?)


Thank you

 

[Jim Rech]

Application.DisplayAlerts = False is the usual way to block the alert. I
imagine it works with shared files but haven't tested it.

 

[Patrick]

so easy when you know how

yes it works

Thank you

Patrick