K
KevinD
I wrote a spreadhseet for our company that uses VBA code. One thing it does is
automatically saves a "backup" of the file to a server on our network every
time the
file is saved locally. Normally there are no errors at all during use.
However, if
the user closes Excel with several documents open and selects "Save All"
from the
prompt, Excel lockes up the spreadsheet gives an "Out of memory" error.
Other
times it gives a "Subscript out of range" error. Again, if each spreadsheet
is saved
and closed on at a time, all is fine. Any ideas? I suspect it is all too
much for the
computer to handle at once (it is a bit slow), but it still shouldn't cause
lock ups.
I tell everyone to save and close one at a time, but apparently we have some
rebels
here.... sigh.
automatically saves a "backup" of the file to a server on our network every
time the
file is saved locally. Normally there are no errors at all during use.
However, if
the user closes Excel with several documents open and selects "Save All"
from the
prompt, Excel lockes up the spreadsheet gives an "Out of memory" error.
Other
times it gives a "Subscript out of range" error. Again, if each spreadsheet
is saved
and closed on at a time, all is fine. Any ideas? I suspect it is all too
much for the
computer to handle at once (it is a bit slow), but it still shouldn't cause
lock ups.
I tell everyone to save and close one at a time, but apparently we have some
rebels
here.... sigh.