#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |