I have been using the following to check for and create a folder within a SharePoint folder
This has worked until recently and I'm struggling to find a solution.
I'm assuming somethign has changes in SharePoint recently that is making this not work so if someone could provide a solution that would be super!
TIA
VBA Code:
Set objFSO = CreateObject("scripting.filesystemobject")
strPath = Activeworkbook.Path & "\"
strFolder = strPath & strBranchNo & "\" & strYear
If objFSO.folderexists(strFolder) Then
Else
objFSO.createfolder (strFolder)
End If
Set objFSO = Nothing
I'm assuming somethign has changes in SharePoint recently that is making this not work so if someone could provide a solution that would be super!
TIA