Code to turn this code into a loop doing muliple copies

[fbplaya02]

I need help converting this code to do mulitple copies using the Copy Before function. Also a next function argumenting files that have a worksheet nameD "COMPILED".

Please Login or Register  to view this content.

[fbplaya02]

multiple workbooks I mean, I would like to select multiple files from the application.getopenfilename fuction and then run each file through a loop