VBA Create Folder

[CarlStephens]

Hello All,

I have the below code that create a folder in a path as directed which pulls the information from cells F1 and F3 n the spreadsheet, and I want to change directory path to my One Drive. Can someone guide me as to what the code should look like to include my One Drive address. Thank you

One Dive Address:

https://carnivalcorp-my.sharepoint.com/:f:/r/personal/carl_stephens_seabourn_co_uk

Current code:
Sub NewFolder()
'
If Len(Dir([F3] & [F1], vbDirectory)) = 0 Then
MkDir [F3] & [F1]
MsgBox "Folder created in location"
Else
MsgBox "Folder already exists!"
End If
End Sub

 

[JEC]

Dir is not able to access sharepoint

 

[HomePro]

Your OneDrive should have a dedicated folder in your pc where whatever is placed there syncs to OneDrive.
Set that as your destination folder.

 

[CarlStephens]

Your OneDrive should have a dedicated folder in your pc where whatever is placed there syncs to OneDrive.
Set that as your destination folder.

Thank you. I have the address, but what do I need to amend on the code?