Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 01-04-2018, 07:40 AM
MatthewBragg MatthewBragg is offline Automatic Report Writer Windows 7 64bit Automatic Report Writer Office 2010 64bit
Automatic Report Writer
Join Date: Jan 2018
Posts: 1
MatthewBragg is on a distinguished road
Default Automatic Report Writer


I work in a group where everyday we have to generate reports (In word) for dozens of returned product, using specific text for each variable. I have written Hundreds of reports over the last year, and to save a substantial amount of time, I usually select a closely matching report as a template, using a Boolean search with specific key words. The thought had occurred to me that it may be possible using entry fields in Excel, to automatically generate a report in word, which would add a line of text based on my entry. For example if I Check a Check box, that a "Final Electrical test" was performed, text would be added stating "FET was performed". In addition, I would like Certain specific text from a text field to be added such as Voltage values, and Ideally I could also set it up for Additional options to appear based on my Text fields or check box selections. For Example if I enter a voltage value between 2.8V and 3 Volts (Lets say 2.9V), Options A, B and C will be available, and text stating the voltage was 2.9 volts will be added to the report, or if I enter a value between under 2.8V options D, E and F will become available. Does the idea for this project sound too elaborate? Any ideas where I could start? I have extracted the text from all of my reports over this past year, and sorted it. I just need to figure out, how to get excel to choose which text will automatically be added based on my response. If anyone is interested in assisting me, I can go into more specifics.
Thanks all,
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Filename options when saving in Word 2013 - using report number at top of a report ? swayzak Word 1 09-08-2017 08:54 AM
Automatic Report Writer Not all fields are exported to the Baseline Cost Report - Visual Report Rowena Project 3 05-30-2016 04:24 PM
Automatic Report Writer Copy matching data from one report cell to another cell report mbesspiata Excel 9 01-15-2015 01:49 PM
Automation Process of Schedule Report Output and Report Check Score Card ! ozman86 Word VBA 1 11-19-2014 11:52 PM
Doc Paragraphs are Full Justified but not Printing to XPS Writer with Justification - mmword Word 0 02-23-2011 04:08 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:55 AM.

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