View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Lord Kelvan Lord Kelvan is offline
external usenet poster
 
Posts: 2
Default copyfile method path not found

nevermind i did some more searching and found this method

Sub MakeMultiDir(FullPath As String)
Dim V As Variant
Dim N As Long
Dim S As String
V = Split(FullPath, "\")

For N = LBound(V) To UBound(V)
S = S & V(N)
If Dir(S, vbDirectory) = vbNullString Then
MkDir S
End If
S = S & "\"
Next N
End Sub

and it seems to work fine