Create a folder in One drive using Excel VBA

Question

Create a folder in One drive using Excel VBA

Chandrakanth Gajawada 1

I am trying to create a folder in One Drive using Excel VBA but I am getting a run time error. Please help

Sub Script()

Folderpath = (Application.ActiveWorkbook.Path) & "/"
usrdt = Format(Date, "DDMMMYYYY") & "-" & Format(Now(), "HHmmss")
VBA.FileSystem.MkDir (Folderpath & usrdt)

End Sub

Carlos Solís Salazar 18,191 Reputation points MVP Volunteer Moderator

2022-07-17T13:13:42.167+00:00

Thank you for asking this question on the **Microsoft Q&A Platform. **

You have not received answers or comments to your question because it may be ambiguous or confusing.

I recommend you visit How to write a quality question and verify that your question meets some of the recommendations.

Hope this helps,
Carlos Solís Salazar

----------

NOTE: To answer you as quickly as possible, please mention me in your reply.

Your answer

Carlos Solís Salazar 18,191 Reputation points MVP Volunteer Moderator

2022-07-17T13:13:42.167+00:00

Thank you for asking this question on the **Microsoft Q&A Platform. **

You have not received answers or comments to your question because it may be ambiguous or confusing.

I recommend you visit How to write a quality question and verify that your question meets some of the recommendations.

Hope this helps,
Carlos Solís Salazar

----------

NOTE: To answer you as quickly as possible, please mention me in your reply.

Share via

Create a folder in One drive using Excel VBA

Your answer