I have a piece of code that opens a separate Workbook, copy and pastes a few columns, saves and closes the separate workbook: (YYZ.xlsm). I have about 30 other Workbooks in a folder I want to do this to. How can I change this to just open a folder and do the copy and paste function to all workbooks in the folder? Just loop through a folder of workbooks: YYZ, YYX, YYA etc... performing the same function.
Workbooks.Open Filename:= _
"K:\DRIVE\FOLDERPATH\FOLDERPATH\FOLDER\YYZ.xlsm"
Application.AskToUpdateLinks = False
Windows("Final.xlsm").Activate
Columns("J:K").Select
Selection.Copy
Windows("YYZ.xlsm").Activate
Sheets("Atts").Select
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
ActiveWorkbook.Save
ActiveWindow.Close
End Sub
Thanks
Bookmarks