Need help saving to multiple locations

[Bruise]

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

 

[Joel]

Find out which write is slowing down the macro by commented out statementts
one att a time. I suspect the network drive G: is probabbly the problem. I
would right click the G: drive in windows explorer and check properties free
disk space. G: drive is either badly fragmented or there is very little free
space left on the disk.

 

[Bruise]

I'm sure the G: drive is probably fragmented, but I don't have access to
that area as it's only our IT people who can do that. If I have to, I can
let the program wait while it saves. It's more important that it actually
saves moreso than saves fast.

I do need it to automatically overwrite the existing file rather than ask
permission. Any suggestions?

 

[Joel]

Why don't you delete the backup before saving. If there is too little space

 

[Bruise]

I could do that, but if the 'readonly' people were logged into the backup
copy, can I still delete it and then save?

 

[Joel]

When a file is opened in read only it really is a copy of the original file.
If you have write permission yo can still save the file and delete the file.
I did a simple experiment.

Start Button - Run - excel /read c:\book1.xls

I then went and deleted book1.xls. I was able to delete the file and the
opened book ramained opened.