#1
|
|||
|
|||
Word form with the intent of Excel export
Hi,
This question is broad and there is definitely multiple solutions. However, here goes: I am working with requirements specification for both hardware and software. The way we structure these is a bit depending on the project but in general we like to have the following things in each requirement:
All this is inserted in a word document along with a simplified excel-sheet where the bidders are supposed to out answer. It is made in excel due to the answers result in points and is later used for evaluation purposes. Since the word document sometimes contains a few hundred requirements the work to create excel sheets are somewhat time consuming even if the process is half automated and there is alot of proofreading and corrections to be done. There is also the risk of misses in the editing when having the information in two places. Now to my actual question. Is there anyone with a good idea (or a template) on how this could be structured or made in a better way to ease the process? I have been thinking of making forms of the requirements and adding editable fields, locking everything else and then doing some VBA to generate an "evaluation report". Not knowing all the capabilites of exporting word-forms and the controllability of it, I'd like some pointers if that would be a good idea before starting up a building it. Basically, any pointers from GURUs in this community is extremely appriciated. |
#2
|
||||
|
||||
The data from Word forms may be exported to Excel - see
http://www.gmayor.com/ExtractDataFromForms.htm I would recommend the use of content controls to collect the data to which end you might find https://www.gmayor.com/insert_content_control_addin.htm useful. I will leave it to you to determine what information is required to be input into the form.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
Seems like it would be a good idea to use the form/content control-export method.
How could I handle the numbering in a good way? Since headers level 1,2,3 is for structure it is nice to have the numbering synchronized with that. Any ideas? |
#4
|
||||
|
||||
Quote:
To see how to do a wide range of calculations in Word, check out my Microsoft Word Field Maths Tutorial: https://www.msofficeforums.com/word/...-tutorial.html For a demo of what can be done in the realm of point calculations, see: https://www.msofficeforums.com/word/...html#post74823 And, for date calculations, should you need them, check out my Microsoft Word Date Calculation Tutorial: https://www.msofficeforums.com/word/...-tutorial.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Quote:
Or is there any great summary formulas that I missed? |
#6
|
||||
|
||||
Whether you actually need to use such complexity really depends on how your document is structured. If these formfields are in single column in a table (or even across multiple tables in which the column varies from table to table), for example, all you need is a relatively simple formula field to sum the relevant table/column values.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Export Word Drop-Down Content Control to Excel Specific Sheet | nolanthomas32 | Word VBA | 4 | 09-19-2017 06:25 AM |
VBA Export Data as Text from Excel to Word | lwbarnes | Word VBA | 3 | 06-09-2016 02:47 PM |
Export Word Form Data to Access | pboland | Word VBA | 1 | 06-12-2015 06:53 PM |
Export VBA form Data to CSV | rhys.downard | Outlook | 0 | 02-29-2012 07:35 AM |
Through VBA, export range from Excel to Word | duugg | Word VBA | 0 | 08-24-2009 07:50 PM |