Recovering from temporary loss of network drive - Excel VBA problem
 

Thanks Dave for your last suggestions,

I've been off sick the last couple of days. However, I had a chance t
try your .saveAs suggestion and I'm afraid I cannot save the file t
the network or anywhere on the local drive, even when the network i
available again. Nor is the file in the Temp folder.

However, I think that I can open another file on the local drive an
copy/paste the data to that. So I am thinking of writing code to d
this and then shut down all the files on the network without savin
them. I also thought that this code could be inserted in a BeforeSav
sub in the file's workbook.

A second macro could later restore this rescued data to the main fil
when the network is available again.

I take your point about the Autosave idea. Sometimes I wondered if
have any marbles left! Thanks for the link anyway.

I will let you know how this goes when I get back to work on Monday. O
course if you should have any other ideas........

Thanks again
Pau

--
Paul
-----------------------------------------------------------------------
PaulC's Profile: http://www.excelforum.com/member.php...nfo&userid=756
View this thread: http://www.excelforum.com/showthread.php?threadid=27618

Recovering from temporary loss of network drive - Excel VBA problem
 

There's a .savecopyas that will create a copy of the workbook.

Maybe you could do something with that. (But I don't have any idea what!)

PaulC wrote:

Thanks Dave for your last suggestions,

I've been off sick the last couple of days. However, I had a chance to
try your .saveAs suggestion and I'm afraid I cannot save the file to
the network or anywhere on the local drive, even when the network is
available again. Nor is the file in the Temp folder.

However, I think that I can open another file on the local drive and
copy/paste the data to that. So I am thinking of writing code to do
this and then shut down all the files on the network without saving
them. I also thought that this code could be inserted in a BeforeSave
sub in the file's workbook.

A second macro could later restore this rescued data to the main file
when the network is available again.

I take your point about the Autosave idea. Sometimes I wondered if I
have any marbles left! Thanks for the link anyway.

I will let you know how this goes when I get back to work on Monday. Of
course if you should have any other ideas........

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