MissaLissa
New Member
- Joined
- Jul 2, 2013
- Messages
- 26
I have approx 30 workbooks that I need to move to different folders based on the workbook name. The folders that these files are being moved to already exist. I have some code but it only moves one file, I need help moving them all.
Move LTCi_Operations.xlsx to folder named IAS Operations
Move AS_Operations.xlsx to folder named AS Operations
Move Assessment_Services.xlsx to folder named Assessment Services
Etc...
Move LTCi_Operations.xlsx to folder named IAS Operations
Move AS_Operations.xlsx to folder named AS Operations
Move Assessment_Services.xlsx to folder named Assessment Services
Etc...
Code:
Sub Move_Final_Reports()
sSaveFrom = "D:\Final Reports\"
sSaveTo = "D:\Final Reports\LTCi\IAS Operations\"
sFile = "*LTCi_Operations*.xl*"
Set FSO = CreateObject("scripting.filesystemobject")
FSO.MoveFile Source:=sSaveFrom & sFile, Destination:=sSaveTo
End Sub