d, yyyy -
Thanks again for your help, Don. I appreciate your assistance. I had
looked extensively though many of those options you suggested before
posting here, but without success. I began looking for some ancillary
and similar problems today and found some hints that helped. Using
several similar solutions, I was able to craft the following, which
works perfectly with a UNC path. I am not sure if it is as efficient as
it could or should be, but it works perfectly for both cases of when
the UNC path is available and is not available.
If anyone has any recommendations to tidy this up, please share...
Otherwise, I am happy with the way it is.
On Error Resume Next
stringvariable =3D ""
stringvariable =3D Dir("\\your\UNC\path\here\", vbDirectory)
If Err.Number <> 0 Then
MsgBox "Cannot archive. Server UNC Path \\your\UNC\path\here\ is not
If stringvariable <> "" Then