I had a question opened earlier today about moving a files from one directory to another using a vb script. The script provided help me on my local drive....but I have additional uses for it. I modified the variables and tried to process on my network but keep getting an error message that the files are not found. I checked the location of the files and they are there. I know there is probably a simple error in the changes I made. I have attached the code for reference.
Dim fso As Object
Dim sSourceDir As String
Dim sTargetDir As String
sSourceDir = "K:\Public\Marketing Secure\Shared\"
sTargetDir = "K:\Public\Marketing Secure\Shared\Oracle Files\"
Set fso = CreateObject("Scripting.FileSystemObject")
fso.movefile Source:="Costs*.xls", Destination:=sTargetDir
fso.movefile Source:="Status*.xls", Destination:=sTargetDir