VBA - copy sheet from Excel to Word

[NYPEN]

Hi,

I have one word template with bookmarks included. I have to have a macro in word which open a browse window to select an excel file, copy a specific sheet (in every excel file the sheets are with same names) from it to specific bookmark in the word doc.
The table in the doc file have to be with the format from the excel file or have to be auto fitted in the doc.

Thank you in advance for the help!

N

[macropod]

This sort of thing has been answered before. See, for example: http://www.vbaexpress.com/forum/showthread.php?63840-Copy-Paste-A-Filtered-Excel-Table-into-Word

[gmayor]

Cross posted (and answered) at https://www.msofficeforums.com/word-vba/44483-vba-copy-sheet-excel.html

[macropod]

Nypen,
Please read VBA Express' policy on Cross-Posting in Rule 3: http://www.vbaexpress.com/forum/faq.php?faq=new_faq_item#faq_new_faq_item3