Tx data from Excel Embedded Object to Word Table

Q

QB

I have an Excel template with 10 embedded Word documents.
I receive completed templates from 12 different business
units. Currently, I cut and past the text from Excel to a
word table - but am getting a little fed up with the 120
cut & paste operations I have do to create my consolidated
report.

Can anybody help me to write the code to link the data
from the templates to a Word table? I am fairly adept with
Excel VBA but have no exposure to Word VBA.

Help please.

QB
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Extract embedded excel file from word document 0
Paste to excel from word - auto format problem 1
Linking data in MS Word into Excel 5
Pasting a cell into bookmarked table from excel vba 1
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
VBA code in Excel opens Word template and fills bookmarks, but can't get correct formatting 5
How to create word template with data from excel 0

Top