Using Network folders
 

Try using this Windows API function:

Declare Function SetCurrentDirectoryA Lib "kernel32" (ByVal lpPathName As
String) As Long

Sub SetDir(PathStr as String)
SetCurrentDirectoryA PathStr
End Sub

Just call SetDir with the path you want:

SetDir \\Whatever\...

Put the declaration at the top of the module.

--
Jim Rech
Excel MVP