Free for PREMIUM members
[Webinar] Streamline your web hosting managementRegister Today
Public Function DoesFileFolderExist(strfullpath As String) As Boolean
'25/10/2010, RB: sourced from www.excelguru.ca/node/30 by Ken Puls
'note it only checks for the existence of the lowest folder (or the file) in the strfullpath string.
On Error GoTo EarlyExit
If Not Dir(strfullpath, vbDirectory) = vbNullString Then DoesFileFolderExist = True
On Error GoTo 0
Open in new window
if DoesFileFolderExist("change as required to the Folder name") then
'code if folder exists...
'folder doesn't exist therefore...
msgbox "Folder doesn't exist"
The revolutionary project management tool is here! Plan visually with a single glance and make sure your projects get done.