Saving over a read only file
- From: lawson <lawson@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 27 May 2005 10:11:01 -0700
i have a program that saves the open spread sheet over the previous revision
in 4 different locations on the server. the problem is that one of the
locations has the the current file in a read only format, and an error pops
up that it cant save over it. is there a way around this? its the
'Server-1\Released' folder that has the files in read only format.
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:="\\Server-1\Estimator\" &ActiveWorkbook.Name
ActiveWorkbook.SaveAs Filename:="\\Server-1\Released\" &ActiveWorkbook.Name
ActiveWorkbook.SaveAs Filename:="C:\Documents\" & ActiveWorkbook.Name
ActiveWorkbook.SaveAs Filename:="C:\Backup\" &ActiveWorkbook.Name
Application.DisplayAlerts = True
.
- Follow-Ups:
- Re: Saving over a read only file
- From: Tom Ogilvy
- Re: Saving over a read only file
- Prev by Date: Re: read excel worksheet
- Next by Date: Rename existing tabs
- Previous by thread: Import Data macro
- Next by thread: Re: Saving over a read only file
- Index(es):
Relevant Pages
|
