Checking for a network drive

[Mark Edwards]

HI,
I have written a macro which periodically saves a spreadsheet to a network drive. However i am getting a problem when the network drive is not present.
What i want to do is to check if a drive is present if it is do the save as normal, if not save to the local disk, so that no data is lost.
Thanks

Mark Edwards

 

[Andrew Poulsom]

Follow this link:

http://www.mrexcel.com/board/viewtopic.php?topic=20935&forum=2