Tuesday, 2 October 2012

How To Create a Directory or Folder with Excel VBA Macro

Excel VBA Macro To  Make a Directory or Folder
Sub MakeDir()
Dim P As String
P = "C:\Documents and Settings\Administrator\My Documents"
'You Can Specify Your Desired Path Where to Create a Directory or Folder
MkDir P & "\" & "MyFolder"
End Sub

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts