MS Word Macro - Numeric field insertion with automatic calculation at end of page
- by Will
Hi,
I am trying to duplicate a feature that exists in Multimate (Ashton Tate) word
processor. Yes, the one that hasnt been supported for 20 years!
If I can duplicate this one feature I can get all the users off MM and onto
Word.
The documents they create are billing documents. they consist of a descriptive
paragraph of any length on the left side of the page, and a billing amount at
the end of the paragraph over on the right hand side, like this (excuse the imperfect formatting)....
+-----------------whole page--------------------+
|
|
| pppp-para 1-pppppppppp
|
| p
p
|
| p
p
|
| p
p
|
| p
p
|
| p
p
|
| p
p
|
| pppppppppppppppppppp $$$$$
|
|
|
|
|
| pppp-para 2-pppppppppp
|
| p
p
|
| p
p
|
| p
p
|
| p
p
|
| p
p
|
| p
p
|
| pppppppppppppppppppp $$$$$
|
|
|
|
|
|
etc
|
+-----------------------------------------------------+
some of these bills can be a few hundred pages and have a dozen or so paragraphs
on each page, which is why none of the users will leave MM until this efficient
little feature can be duplicated. The thing that MM does really easily is that
there is a function key that they can press at any time that will -
- jump the cursor from the paragraph they are writing over to the right hand
side
- create a numeric field
- allow them to enter a number into the numeric field
- return them to the left hand side to start a new paragraph
What MM also does is automatically total the numeric fields on each page and
create a subtotal in the page footer. it also creates a total for the entire
document and puts this in the footer of the last page.
I would like to duplicate this feature in word with a macro, but have no idea
where to start. Any suggestions or code would be great,
thanks,
will.
