Copy worksheet from closed workbook into active/existing workbook.

Dear VBA experts,

Basically i want to copy a worksheet ("Document") from a closed workbook ("filepath") into the exisiting/current/active one. I need this a generic code, so whatever spreadsheet i am in it will copy the document tab from the set pilepath to the current one. The document tab from the filepath will always be the same however i want the macro to work in any workbook.

Help would be much appreciated.

Thank You

Rasik.

Hi,
welcome on the board rasik,
maybe something like this: http://www.ozgrid.com/forum/showthread.php?t=145225
Regards
Mark

Dear Mark,

Thank You for replying quickly and apologies for late reply. I looked at the thread you attached but that worksheet has a macro and that needs to be copied hence i need the formatting is this possible to do?

Thanks Rasik