Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 temporary files remains on network shares | Excel Discussion (Misc queries) | |||
Excel 2003 - problem saving to a mapped network drive | Excel Discussion (Misc queries) | |||
Link workbooks-C drive to network drive | Excel Worksheet Functions | |||
Recovering from temporary loss of network drive - Excel VBA problem | Excel Programming | |||
Recovering from temporary loss of network drive - Excel VBA problem | Excel Programming |