We're all currently working from home and I've hit some performance issues across our VPN when saving reports to server file shares. So to get round it for the moment I'm sending them to a folder on the local C: drive. I have a very basic test as follows:
Code:
OutPutPath = "C:\temp\"If FileExists(OutPutPath) Then
' Carry on
Else
'throw an error
End If
' The fileexists function is.....
Public Function FileExists(ByVal path_ As String) As Boolean
FileExists = (Len(Dir(path_)) > 0)
End Function
On both my laptop and my colleague's there is definitely a folder called temp off the root of C: On my laptop it works perfectly but on my colleague's it fails every time with FileExists returning False. I'm completely stumped. Can anyone suggest anything?
Incidentally, I have tried skipping the FileExists test and going straight in to the report output code but that goes straight in to debug as I guess it thinks the folder doesn't exist.