SantanaKRE8s
Board Regular
- Joined
- Jul 11, 2023
- Messages
- 131
- Office Version
- 365
- Platform
- Windows
Hello,
Can someone help with this vba code, Im trying to move some files from my desktop to a diferent location but I keeo getting error
Run-time error '75'
Path/file access error
Option Explicit
Sub MoveFile()
Dim sfolder As String
Dim dfolder As String
sfolder = "\\txfil001\Bsantana$\Desktop\"
dfolder = "\\txfil002\group\Branches\VS-SpaceX\Benjamin\FABRINET_THF002\CANCELED POs\"
Name sfolder & "THF002.xlsx" As dfolder & "FBN CANCEL REQUEST.xlsx"
Name sfolder & "CANCEL.xlsx" As dfolder & "Xpress List.xlsx"
End Sub
Can someone help with this vba code, Im trying to move some files from my desktop to a diferent location but I keeo getting error
Run-time error '75'
Path/file access error
Option Explicit
Sub MoveFile()
Dim sfolder As String
Dim dfolder As String
sfolder = "\\txfil001\Bsantana$\Desktop\"
dfolder = "\\txfil002\group\Branches\VS-SpaceX\Benjamin\FABRINET_THF002\CANCELED POs\"
Name sfolder & "THF002.xlsx" As dfolder & "FBN CANCEL REQUEST.xlsx"
Name sfolder & "CANCEL.xlsx" As dfolder & "Xpress List.xlsx"
End Sub