#1
|
|||
|
|||
Auto exporting data/tables into a word template
I currently have a complex excel spreadsheet which calculates a large number of different things based on the client data inputted. The results are outputted into specific tables, templated text etc.
I also have a Word template, where the tables/text from the spreadsheet above are meant to appear in pre-determined sections (note page number will not always be the same, but the position in the document will always be the same in terms of chronological order). I'd like to automate this process, so the excel spreadsheet and the templated word file 'talk' to each other. This would involve the excel tables/text automatically importing into the specified areas in the word template. An example of this would be a 'goals and objectives' table in the excel spreadsheet automatically importing into the 'Your goals & objectives' heading of the word template. After some googling - it seems the answer lies in VB programming/macro's. Is anyone able to help me out with that please? |
#2
|
||||
|
||||
If you copy an Excel range and paste it into Word using Paste Special with the 'Paste Link' option and choose an appropriate format, the Word document will be linked to that Excel range. Any changes to the Excel range will be reflected in the Word document. No code required.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word 10 Tables: Column to auto number 1.1, 1.2 etc in sequential rows | FrauBaker12 | Word Tables | 7 | 06-24-2016 11:52 PM |
Data transfer from Word tables to Excel | shoro | Word | 4 | 10-01-2013 05:08 AM |
how do I auto-populate a word template | Greenhorn | Word | 4 | 09-05-2012 04:16 PM |
Word normal template changed??? Auto correct file??? | Frankwhoa | Word | 0 | 03-10-2010 04:46 PM |
Exporting data | dsmithers | Outlook | 2 | 06-24-2009 09:58 AM |