Horje
vba create folder if not exist Code Example
vba create folder if not exist 
'requires reference to Microsoft Scripting Runtime
Function MkDir(ByVal strDir As String, ByVal strPath As String)
  	Dim fso As New FileSystemObject
  	Dim path As String
	path = strPath & strDir
	If Not fso.FolderExists(path) Then
	    fso.CreateFolder path
	End If
End Function
Source: stackoverflow.com
vba create directory if not exist 
'Don't requires refernce of Microsoft Scripting Runtime
Path = "D:\FolderName\"
If Len(Dir(Path, vbDirectory)) = 0 Then
   MkDir Location
End If



Vb

Related
date format for ms chart vb.net Code Example date format for ms chart vb.net Code Example
vba continue for each loop Code Example vba continue for each loop Code Example
vba get text file content Code Example vba get text file content Code Example
excel insert blank row for value change in column Code Example excel insert blank row for value change in column Code Example
extract word in a text in excel Code Example extract word in a text in excel Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 8



 

Horje