Transfer Calculator Result

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed - 31 Aug 2006 03:36 GMT

I know how to display the Microsoft calculator in Word.

MS says that a two step 'Copy/Paste' operation is the only way to capture
the result of a calculation. Is there any way via VBA to more directly
capture the answer and automatically get the calculator's answer into the
document or into a form field (by clicking one button, for example)?

Thanks,

Ed (in Virginia)

Reply to this Message

Doug Robbins - Word MVP - 31 Aug 2006 04:49 GMT

I don't believe that the calculator exposes itself to the use of VBA. You
could however use vba to ask the use for the inputs to the calculation and
to perform the calculation.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I know how to display the Microsoft calculator in Word.
>
[quoted text clipped - 6 lines]
>
> Ed (in Virginia)

Reply to this Message

Jezebel - 31 Aug 2006 05:29 GMT

or use the dreaded SendKeys

>I don't believe that the calculator exposes itself to the use of VBA. You
>could however use vba to ask the use for the inputs to the calculation and
[quoted text clipped - 10 lines]
>>
>> Ed (in Virginia)

Reply to this Message

Helmut Weber - 31 Aug 2006 12:38 GMT

Hi Ed,

Ctrl c copies the calculator's result,
or whatever is displayed to the clipboard.
As you have to type into the calculator anyway,
it's just one keystroke more.

To read from the clipboard programmatically,
google for dataobject, getfromclipboard, gettext

HTH

Signature

Greetings from Bavaria, Germany
Helmut Weber, MVP WordVBA
"red.sys" & chr(64) & "t-online.de"
Word 2002, Windows 2000 (german versions)

Reply to this Message

Jay Freedman - 31 Aug 2006 15:01 GMT

> Hi Ed,
>
[quoted text clipped - 7 lines]
>
> HTH

Or start with
http://www.word.mvps.org/FAQs/MacrosVBA/ManipulateClipboard.htm.

Signature

Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

Reply to this Message

Roy - 01 Sep 2006 09:10 GMT

Thanks, all. I know what I am going to do now.

-Ed

Reply to this Message