VBA – File & Directory Handling

Create folder if not exist

Sub create_folder_()

'
folder_path = "C:\Users\aashish mittal\Downloads\learnskill"

If Dir(folder_path, vbDirectory) <> "" Then
MsgBox "exist"
Else
MsgBox "not exist"
MkDir folder_path
End If

End Sub

Create file if not exist

Sub check_file_exist()

filePath = "C:\Users\aashish

Read More
Call Now