View Single Post
 
Old 02-25-2020, 10:14 AM
NPen NPen is offline Windows 7 64bit Office 2010
Novice
 
Join Date: Feb 2020
Posts: 3
NPen is on a distinguished road
Default VBA - copy sheet from excel

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
Reply With Quote