I am trying to use the .movefile to move multiple files from one directory to another and I am getting the error file not found. I have checked and all the files are there.
according to the help .movefile should be able to move mutiple files, and I can't figure out what it is doing.
Any help would be appreciated.
Thanks
To go where no programmer has gone before.
Code:
Set fso2 = New Scripting.FileSystemObject
tempdate = Format(Date, "yyyymmdd")
fso2.MoveFile "C:\temptest\" & tempdate & " *.*", "C:\temptest\Archive\"
according to the help .movefile should be able to move mutiple files, and I can't figure out what it is doing.
Any help would be appreciated.
Thanks
To go where no programmer has gone before.