Creating new Folder in Sharepoint directory using VBA Excel

[Sagar0650]

I am trying to create the new folder on sharepoint using Mkdir but it is not working.
is there any other way of doing it?
Thanks in advance for help

 

[severynm]

Do you have the SharePoint folder(s) synced to your computer? What exactly is not working? Do you get errors? What do they say? What is the code you have been using? For the best chance for an answer, please provide as much information as is relevant.

 

[Sagar0650]

This is the code, it's very simple 2 line of code where i just want to create the folder on sharepoint

Sub crfolder()

    usrdt = Format(Date, "DD-MMMM-YYYY") & "-" & Format(Now(), "hh.mm AMPM") & "/"

        MkDir "//mysite.sharepoint.com/teams/test1/test2/" & usrdt
 
End Sub

this gives me an runtime error '76': Path not found
i have tried with both forward & back slash

 

[severynm]

Yep - as far as I know you're not going to be able to create folders with MkDir using a web URL. Sync the SharePoint directory to your computer. You'll then end up with a path something like C:\Users\%UserName%\SharePointCompanyName\SharePoint\Folder\Path\ that is local to your computer that you can use with MkDir. As an example,

Sub CreateSharePointDirectory()
    Dim folderPath As String
    Dim ans As String
    Dim userName As String
    userName = Replace(Application.userName, " ", ".")
    folderPath = "C:\Users\" & userName & "\SharePointCompanyName\SharePoint\Folder\Path\"
    If Dir(folderPath, vbDirectory) = vbNullString Then
        ans = MsgBox("Folder does not exist. Create?", vbYesNo)
        If ans = vbYes Then
            MkDir folderPath
        Else
            Exit Sub
        End If
    End If
End Sub

 

[Sagar0650]

Thank you for response but is there any way of creating folder on sharepoint, without syncing sharepoint to my computer.
maybe not using mkdir but with something different.
any suggestions around it would be appreciated.

 

[severynm]

but is there any way of creating folder on sharepoint, without syncing sharepoint to my computer

I don't know if any of these will work as I have never tried them (as everything I need to work on is already synced), but a quick google search yields some possible directions to take.

Creating a new folder in Sharepoint using VBA

I'm trying to automatically save workbooks using VBA to a Sharepoint folder- which needs to be created first. Code I have below works ONLY for saving the file. The MkDir function returns a Run-time...

stackoverflow.com

VBA - Checking Folder/File exist in SharePoint

I wanted to copy a local file to sharepoint library using VBA by clicking an image. Right now seems like I'm unable to check for Folder & Files on SharePoint. As every time I ran the code(by

stackoverflow.com

Create sharepoint document folder using VBA

I need to find a way to programmatically, using Excel VBA, create a folder in a Sharepoint Document Library. The Sharepoint Document Library already exist, and it has already one level of folders i...

sharepoint.stackexchange.com

Two of those answers seem to center around temporarily mapping the SharePoint directory to a drive letter (specifically the first and second links).