excel vba if folder exists
'Input parameters
'@Param strFileFullPath: String. Full path to the folder.
'Local path example: "C:/myFolder"
'SharePoint path example: "\\my.sharepoint.com\Shared%20Documents"
'Local network path example: "\\SOMEONES-PC\Users\Public\Documents"
'Output Parameters
'@Param FolderExists: Boolean.
Function FolderExists(strFolderPath As String) As Boolean
Dim objFSO As Object
Set objFSO = CreateObject("Scripting.FileSystemObject")
If objFSO.FolderExists(strFolderPath) Then FolderExists = True
Set objFSO = Nothing
End Function