Copying Workbooks to a New Folder

  • I want to create a macro that can automatically:

    -copy all the excel sheets in a folder
    -paste these excel sheets in a new folder

    I've found various information about how to move copy and paste data from one worksheet to another, or how to combine data into one 'master' spreadsheet, but nothing about copying workbooks and pasting them in a new folder.

    Any suggestions or tips?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!