| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to save shared file
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 -- Patrick |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to save shared file
Application.DisplayAlerts = False is the usual way to block the alert. I
imagine it works with shared files but haven't tested it. -- Jim Rech Excel MVP "Patrick" wrote in message ... 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 -- Patrick |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to save shared file
so easy when you know how
yes it works Thank you Patrick "Jim Rech" wrote: Application.DisplayAlerts = False is the usual way to block the alert. I imagine it works with shared files but haven't tested it. -- Jim Rech Excel MVP "Patrick" wrote in message ... 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 -- Patrick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you automaticaly save a shared file every few mintues? | Excel Discussion (Misc queries) | |||
| Edited links keep reverting when we save a shared network file. | Excel Discussion (Misc queries) | |||
| Shared workbook - to save or not to save | Excel Discussion (Misc queries) | |||
| Shared File Doesn't Always Save | Excel Discussion (Misc queries) | |||
| Save File to Another Directory, but not change Users File Save location | Excel Programming | |||
Linear Mode
