Recovering from temporary loss of network drive - Excel VBA problem
 

Hi Dave

Many thanks for your code which is a lot neater than my effort.

I have tried your suggestion of *saving as * to the temp folder but it
wont save that way either. However, if I try to open the file again it
says there is another copy already open.

The NT4 event viewer records an event ID 3009 'The redirector failed to
unlock part of a file on the server'.

If there is no solution to this, I am thinking of enabling Autosave to
run every 10 mins. Is there likely to be any confict between Autosave
and running any of my macros? If so I presume I could switch it off at
the beginning of each one. Any thoughts on this?

Thanks again

Paul


--
PaulC
------------------------------------------------------------------------
PaulC's Profile: http://www.excelforum.com/member.php...fo&userid=7563
View this thread: http://www.excelforum.com/showthread...hreadid=276187

Recovering from temporary loss of network drive - Excel VBA problem
 

I _think_ I meant just a .saveAs once to the Temp folder and then later another
..saveAs to the network drive--don't reopen the workbook.

Are you sure it didn't saveAs to that temp folder?

I'm not aware of anything that can interfer with your code based on using
Autosave--but if you use autosave and the network drive is disconnected, won't
you have the same problem (but now every 10 minutes).

(There have been posts asking how to disable autosave in code. I'm not sure why
people ask, but it could be because of some problem. One reason I don't like
autosave is that it kills the Undo stack.)

here's a link to a post by Jim Rech:
http://groups.google.com/groups?thre...%40cppssbbsa04

Good luck.

PaulC wrote:

Hi Dave

Many thanks for your code which is a lot neater than my effort.

I have tried your suggestion of *saving as * to the temp folder but it
wont save that way either. However, if I try to open the file again it
says there is another copy already open.

The NT4 event viewer records an event ID 3009 'The redirector failed to
unlock part of a file on the server'.

If there is no solution to this, I am thinking of enabling Autosave to
run every 10 mins. Is there likely to be any confict between Autosave
and running any of my macros? If so I presume I could switch it off at
the beginning of each one. Any thoughts on this?

Thanks again

Paul

--
PaulC
------------------------------------------------------------------------
PaulC's Profile: http://www.excelforum.com/member.php...fo&userid=7563
View this thread: http://www.excelforum.com/showthread...hreadid=276187

--

Dave Peterson