|
|
|
date: Wed, 7 May 2008 12:49:22 -0400,
group: microsoft.public.word.conversions
back
Re: Convert word doc file to excel so column contents can be totaled
With the form unlocked, if you double click any field you will see that it
has a bookmark name eg
the field adjacent to 'Principal Earnings from Employment' is bookmarked
"Text35" .
At the place where you want the result of the calculation, you can use a
Word formula field to total the relevant amounts in place of the form field
at that location. (It is possible to add the fields by macro and insert the
totals in the relevant form field(s), but given your requirement, this only
adds complexity to the issue)
Unfortunately the form appears to have been created by copying and pasting
the fields and has somehow managed to retain the same name for a whole raft
of different fields. Frankly I don't know how the creator managed to do that
as bookmark names must be unique and Word creates a nul entry when a
duplicate name exists, but, however it was done, it cannot remain that way
if you want to perform calculations on the contents.
The first thing to do is to create unique bookmark names for each of the
fields, then you can create a formula field eg
{=({Fieldname1} + {Fieldname2})}
to add all the relevant fields. Check the calculate on exit check box of the
last form field that contributes to the calculation.
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
BillP wrote:
> Thanks, Graham, I got the form unlocked thanks to your guidance. What
> I would like to do is to be able to input data into the form and have
> the total calculated. Can this be done within the Word form or does
> the form have to be moved into Excel and used as a table? I don't
> know how to perform calculations within Word.
> The data doesn't need to be saved, I just need to print the form with
> the input data and totals.
> TIA
> Bill
>
> "Graham Mayor" wrote in message
> news:eAcZNfMsIHA.1952@TK2MSFTNGP05.phx.gbl...
>> It is just a simple document template protected for forms. You can
>> unprotect it by clicking the padlock on the forms toolbar. There are
>> no calculations associated with the form, but you can add them, or
>> you could extract data that has been entered into the documents
>> created from the form http://gregmaxey.mvps.org/Extract_Form_Data.htm
>>
>> --
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>> Graham Mayor - Word MVP
>>
>> My web site www.gmayor.com
>> Word MVP web site http://word.mvps.org
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>
>>
>> BillP wrote:
>>> I have a word document located here:
>>> http://www.sccourts.org/forms/word/SCCA430.dot that I would like to
>>> copy into an excel spreadsheet so that I can total the columns. The
>>> document seems to be protected as I cannot copy any data from it.
>>> How can I do this? TIA
>>> BillP
date: Thu, 8 May 2008 13:46:20 +0300
author: Graham Mayor
|
|
