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

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" wrote:

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

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" wrote in message
...
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" wrote:

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

Why don't you delete the backup before saving. If there is too little space
on network drive, then you have to start complaining to your MIS people.

"Bruise" wrote:

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" wrote in message
...
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" wrote:

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

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

"Joel" wrote in message
...
Why don't you delete the backup before saving. If there is too little
space
on network drive, then you have to start complaining to your MIS people.

"Bruise" wrote:

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" wrote in message
...
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" wrote:

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

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.

"Bruise" wrote:

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

"Joel" wrote in message
...
Why don't you delete the backup before saving. If there is too little
space
on network drive, then you have to start complaining to your MIS people.

"Bruise" wrote:

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" wrote in message
...
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" wrote:

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