Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-16-2015, 12:41 PM
pythonturq pythonturq is offline How to automate many word and excel files at once Windows 7 32bit How to automate many word and excel files at once Office 2013
Novice
How to automate many word and excel files at once
 
Join Date: Oct 2015
Posts: 1
pythonturq is on a distinguished road
Default How to automate many word and excel files at once


Hello everybody,
I often have to write many reports at work. These reports are word files and some are excel files. These are almost statick files that i only have to change 2,3 words and print it out and put it in its folder. What is my best option to make an automation . I am thinking of like filling a form and when submitted each value go to its correct place in its correct file. IS this possible?
Thank you.
Reply With Quote
  #2  
Old 10-16-2015, 06:00 PM
macropod's Avatar
macropod macropod is offline How to automate many word and excel files at once Windows 7 64bit How to automate many word and excel files at once 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

If there are only a few words to change, I'd suggest putting those words into, say, a reference Excel workbook on their own. You can then link all your report workbooks and documents to the changeable content in this reference workbook. Once you've done that, updating the lot requires nothing more than updating the reference workbook.
__________________
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 automate many word and excel files at once Opening Word /Excel reinstalls files, loses recent files adj1 Office 3 05-10-2013 12:27 AM
Excel VBA to automate PowerPoint CatMan PowerPoint 2 04-11-2012 04:50 PM
Automate Data from Excel into Word DropDown...? sigraves Word VBA 0 08-03-2009 06:54 AM
Automate Word to Ask if you Want to Print MrMims Word VBA 0 02-24-2009 06:21 PM
Automate Excel tabname deegz Excel 2 12-08-2008 02:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:52 AM.


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