form with excel and word functionality

[joshua.krinsky]

I'm trying to create a form that allows users to enter goals for the
year (the word part) and then enter weights and scores for those goals
that will be calculated (the excel part).
I've been doing some research on trying to do this and I've reached a
dead end. Here are the options I've been able to come up with and why
they won't work:

1. using excel - no automatic spell check, clunky text interface, no
formatting.
2. protected document with form fields in word - no spell check or
formatting in form fields(why?!?), form field calculations don't work
when document isn't protected
3. table math in word - not able to do what I want it to do, have to
update it
4. embedded excel spreadsheet in word - doesn't line up with the word
parts (no link between goals and scores), clunky interface
5. embedded word doc in excel - same as #4

Does anybody have any other ideas or help to complete this form?
Anybody know why microsoft doesn't integrate more word functionality in
excel(special text boxes?) or more excel functionality in
word(calculations based on bookmarks that don't have form fields)?

Thanks

 

[KC Rippstein]

In an earlier post from today, Dave Peterson suggested the following to
someone else that might be helpful for you (maybe):

It may be time to actually use a userform that gets input from the user.
Instead of designing your own form, you may find using Data|Form easier.
And if that isn't enough, John Walkenbach has an enhanced data form:
http://j-walk.com/ss/dataform/index.htm

Or you can use XML, which works brilliantly with all the Office products you
want.

- KC