Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-28-2013, 12:50 PM
Jazz43 Jazz43 is offline Inputing Text from Excel sheet to multiple Word documents and Visio File Windows 7 64bit Inputing Text from Excel sheet to multiple Word documents and Visio File Office 2010 64bit
Advanced Beginner
Inputing Text from Excel sheet to multiple Word documents and Visio File
 
Join Date: Oct 2009
Posts: 54
Jazz43 is on a distinguished road
Default Inputing Text from Excel sheet to multiple Word documents and Visio File

I have to fill out some paperwork which involves inputting the same information (name, address, phone, etc) into multiple word documents and a visio sheet.



I was hoping I could create one excel or word document to input the information into. Then this document would automatically input the information into all the other documents. I know there is a way to link text boxes, but I just dont know of a way to do that with multiple different files.

Any help would be greatly appreciated!

Thanks


Edit - I should probably mention that I am currently using office 2010 with visio 2003. On my home computer I have Office 2013 installed, so if its much easier to use I can upgrade to 2013 once I figure out how to do it.
Reply With Quote
  #2  
Old 05-30-2013, 02:08 PM
macropod's Avatar
macropod macropod is offline Inputing Text from Excel sheet to multiple Word documents and Visio File Windows 7 32bit Inputing Text from Excel sheet to multiple Word documents and Visio File Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Jazz,

If the workbook is always the same and the Word documents are always the same, you can copy/paste the Excel cells to the Word documents, using the 'Paste Special' method with the 'paste link' option, with whatever paste format best suits your needs. From then on, any changes to the Excel data will be reflected in the documents. I don't use Visio, but I imagine it has something similar.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to import multiple text file data into word mizankabir Word VBA 7 09-15-2023 10:27 PM
Inputing Text from Excel sheet to multiple Word documents and Visio File Replace text in multiple documents? Roscoe Word VBA 7 07-31-2017 04:02 PM
search on multiple word documents Guy Roth Word 7 03-06-2017 01:31 PM
Combining Multiple Word Documents Heading/Figure Issues Word 2007 grantgibson45 Word 1 09-10-2012 11:00 PM
Inputing Text from Excel sheet to multiple Word documents and Visio File Word count in multiple documents cyberpaper Word 5 07-27-2012 07:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:37 PM.


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