Convert word doc file to excel so column contents can be t..

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" <gmayor DeleteThis @REMOVETHISmvps.org> 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
>
>

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" <gmayor DeleteThis @REMOVETHISmvps.org> 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

Graham Mayor schrieb:
> 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.
>

Ok i will try that .