MS Word Macro - Numeric field insertion with automatic calculation at end of page

Posted by Will on Stack Overflow See other posts from Stack Overflow or by Will
Published on 2010-04-08T23:51:16Z Indexed on 2010/04/08 23:53 UTC
Read the original article Hit count: 374

Filed under:
|
|
|
|
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.

© Stack Overflow or respective owner

Related posts about ms

Related posts about word