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.
Thanks
Please Login or Register to view this content.
See if this link helps out at all...or gets you in the right direction..
http://www.ozgrid.com/VBA/2007-files...lternative.htm
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Thanks 4evr, still having trouble incorporating the loop into my code though.
Does this help?
I'm not sure about what you're trying to achieve. This will open all workbooks in a folder. Copy Columns("J:K") to Sheet("Atts") - Each workbook in the folder needs to have this sheet. Save and Close each workbook with the changes. Anyway it might give you some ideas. Note: All other workbooks need to be closed except for those associated with the macro.Please Login or Register to view this content.
Last edited by JOHN H. DAVIS; 01-28-2016 at 03:34 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks