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 |
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 |