copy specific sheet from closed workbook to active workbook

I looking a code that copies from closed workbook in which there are several worksheets

path c:\\sample\proton.xlsx a specific worksheet named WORKINGS and insert it to last sheet in active opened workbook

Thanks if any one can assist

Paste this macro into your open active workbook.Place a command button on your worksheet and assign it to this macro.

Note the third line from the bottom ... you'll need to change SHEET3 to the name of the last sheet of
the active workbook, where the copied sheet will be placed.

Please Login or Register  to view this content.

Thanks works as requested

You are welcome. Thanks for the Add Rep.

If you are satisfied, please mark this thread as SOLVED.


Up top, right side :

Thread Tools