Dear all
I am not skilled enough in VBA codes.
I am looking for a simple VBA code which does the following:
1. It exists a workbook Z with 10 sheets (a, b, c, d, e, ...)
2. The macro should now copy sheet (a) of workbook Z in another new workbook 1; copy sheet (b) of workbook Z into another workbook 2; copy sheet (c) of workbook Z into another workbook 3; copy sheet (d) of workbook Z into another workbook 4 and so on.
Copy paste should be only with values.
And the new workbooks should be saved automatically in a certain path.
Thank you for your help.
I do not attach (yet) an excel, as I believe that the description should be hopefully clear enough.
Best regards
Heinz
Bookmarks