Macro to save copied data

[namluke]

Hi,

The below macro basically copies a work sheet, opens a work book, pastes the copied data, closes the work sheet it just copied and then saves and closed the work book, then it reopens and repeats.

When it saves and closes and reopens the workbook it takes a long time.

Is there a way for it to only save and close the workbook once all the open work sheets to copied and pasted are completed?

Please Login or Register  to view this content.

[shankarsomajni]

Following code will open a folder to pick where all your workbooks (To Copy Data From ) are saved and then will copy them to the current workbook.

Please Login or Register  to view this content.

Let me know if it helps.
Cheers