vba create directory if not exist

Faizan Younas Tanooli answered on June 23, 2021 Popularity 7/10 Helpfulness 6/10

answer vba create directory if not exist

Comment

'Don't requires refernce of Microsoft Scripting Runtime
Path = "D:\FolderName\"
If Len(Dir(Path, vbDirectory)) = 0 Then
   MkDir Location
End If

Popularity 7/10 Helpfulness 6/10 Language vb

Source: Grepper

Tags: create-directory vba

Link to this answer
Share Copy Link

Contributed on Jun 23 2021

Faizan Younas Tanooli

0 Answers Avg Quality 2/10

Oops, You will need to install Grepper and log-in to perform this action.