Skip to content

Instantly share code, notes, and snippets.

@agbishara

agbishara/VBA - Create Folder

Created April 15, 2014 15:58
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save agbishara/10743743 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save agbishara/10743743 to your computer and use it in GitHub Desktop.
Download ZIP
This is a example of how to create sub-folders in Excel VBA
Raw
VBA - Create Folder
Dim WBP As String
Dim VPF As String
WBP = ThisWorkbook.Path & ""
VPF = WBP & "\Generated\VP"
CreateFolder (VPF)
Function CreateFolder(Fnamez As String)
MkDir Fnamez
End Function
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment