Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello group!
I have my workbook on a server that is used by 200+ people. However, only a handful have write access to it; all the rest can read only. I would like to save it to two separate locations on the server (G: drive) and, as a safety precaution, one location on the C: drive. The people with readonly access will access "G:\MainWorkbook2.xls" while the original program will be located under "G:\MainWorkbook.xls" I am using the following code, but it seems to take forever to save. Is there a quicker method, or more efficient method that I can use that will also automatically overwrite the existing files? My current code: ActiveWorkbook.Save ActiveWorkbook.SaveAs "G:\MainWorkbook2.xls" ActiveWorkbook.SaveCopyAs "C:\MainWorkbookBackup.xls" TIA for your help. Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple Users - Different PC/Locations | Excel Worksheet Functions | |||
Ranking based on sum across multiple locations | Excel Worksheet Functions | |||
Save document to multiple locations | New Users to Excel | |||
save to multiple locations simultaneously | Excel Discussion (Misc queries) | |||
How do I advance filter to multiple locations at once? | Excel Worksheet Functions |