Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-03-2016, 04:25 PM
Jiing Chiang Jiing Chiang is offline Auto exporting data/tables into a word template Windows 10 Auto exporting data/tables into a word template Office 2016
Novice
Auto exporting data/tables into a word template
 
Join Date: Jan 2016
Location: Australia
Posts: 11
Jiing Chiang is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 02-04-2016, 02:06 AM
macropod's Avatar
macropod macropod is offline Auto exporting data/tables into a word template Windows 7 64bit Auto exporting data/tables into a word template Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,232
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto exporting data/tables into a word template 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
Auto exporting data/tables into a word template 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
Auto exporting data/tables into a word template Exporting data dsmithers Outlook 2 06-24-2009 09:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft