0

I'm trying to create a folder on SharePoint.

I have code for Excel, that checks if a folder exists. If it doesn't, the code creates it.

I tried to use the MkDir function, but apparently it can't be used with SharePoint.

My URL looks something like this: https://XXXXXX.sharepoint.com/sites/XXXX/Documents%20partages/XXXX/FA

During my research, some people were talking about mapping, but I have no idea what it means.

Is there a way to create a folder using something similar to MkDir?

Improve this question
4
  • MkDir will make folders on the file system of the operating system (e.g. Windows), which are not the same as Sharepoint folders. Sharepoint is a web-based application that has its own methods. This might help mrexcel.com/board/threads/… Commented Mar 3, 2022 at 14:00
  • @ChristopherHamkins Thanks for your answer. I looked at the different links you sent me, but the problem is that, since other coworkers are supposed to use this program, sync directly to the pc doesn't seem to be a great idea, so i'm not sure if there is something similar to MkDir but compatible with SharePoint Commented Mar 3, 2022 at 14:45
  • Have a look at the answer posted by RickJ in stackoverflow.com/questions/53497462/… - this is the method I use and it works well. The only caveat is that a connection must be made first manually using [Open in Explorer] - RickJ mentions this in their answer and I've not found a way to automate this. If I don't restart my machine, that connection usually remains for around a week. Commented Mar 3, 2022 at 16:13
  • Mapping probably means that you map your sharepoint folder to your local drive, and then every change you do to your local folder is reflected by the sharepoint folder. support.microsoft.com/en-us/office/… Commented Jun 4, 2022 at 9:57
Related questions
43
Create a folder and sub folder in Excel VBA
16
FileSystemObject.CreateFolder to create directory and subdirectories
3
VBA MKDIR in SharePoint fails
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.