So I was thinking of using code like this:
to tell whether or not the original is still connected over network drive. However, how do you switch the path to a local backend on C drive using VBA (simplest way possible please!)?Code:If Dir("Drive:\foldername\") = "" Then 'connection not available
thanks