create a folder if it does't exist? [Excel VBA Programming]

Maybe this may help:

            Path = "C:\Excel\MyTest"
            If Dir(Path, vbDirectory) = vbNullString Then
            MkDir sPath
            End If

Use the MkDir Function

MkDir "c:\Excel\Test"

It might be better to test if the Directory exists

If Len(Dir("c:\Excel\Test", vbDirectory)) = 0 Then
    MkDir "c:\Excel\Test"
End If