Ok here is my problem, i am trying to import a file from a server. The server is located in one state while the file is being run from a system in another state. i need code where it opens the directory then pulls the file. This seems to see that the connection is slow and moves on to the next line. could it be this

FName = cPath & Filename

could that be the key to this code, right now it is false, should i change that to

If Dir(cPath & Filename) Exist then (but how do you check if a directy exists?) Thanks


Dim FName As String
serverconnection = "\\util\time\test\"

cPath = serverconnection
Filename = "Updater.bas"
FName = cPath & Filename
If Dir(cPath & Filename) = Filename Then
ThisWorkbook.VBProject.VBComponents.Import FName

Workbooks.Open serverconnection