Panthers0027
Board Regular
- Joined
- Apr 13, 2009
- Messages
- 89
Hello,
I'm using Office 2003. I would like to know how to save a file as Read Only, then re-save over it on a nightly basis.
Every night, I save all the work I do on the shared drive using a "Timer" on Excel.
Sub Timer()
Application.OnTime TimeValue("22:00:00"), "Save_Common_temp"
End Sub
The Macro runs this code:
This basically saves my file over the Network file every night at the same time. The issue is that the shared file is often left open, not allowing me to save over it. If I save it as "Read Only" I can't save over it either.
Any ideas on how to be able to save my updated files on the Shared Network without interruption?
I'm using Office 2003. I would like to know how to save a file as Read Only, then re-save over it on a nightly basis.
Every night, I save all the work I do on the shared drive using a "Timer" on Excel.
Sub Timer()
Application.OnTime TimeValue("22:00:00"), "Save_Common_temp"
End Sub
The Macro runs this code:
Code:
Sub Save_Common_temp()
Workbooks.Open Filename:= "\\BCAFS01.BCARENA.COM\USERS$\TherrienA\Desktop\Other\Renewals & New Biz\0910 New Biz.xls" _
, UpdateLinks:=3
ActiveWorkbook.SaveAs Filename:="S:\Common\Temp\Andre\0910 New Biz.xls"
ActiveWorkbook.Close
End Sub
This basically saves my file over the Network file every night at the same time. The issue is that the shared file is often left open, not allowing me to save over it. If I save it as "Read Only" I can't save over it either.
Any ideas on how to be able to save my updated files on the Shared Network without interruption?