Transfer Calculator Result

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)

Doug
Wed Aug 30 22:49:20 CDT 2006

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.

--
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

"Ed" <ed@pathagoras.com> wrote in message
news:_WrJg.37803$ok5.37232@dukeread01...
>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)
>

Jezebel
Wed Aug 30 23:29:50 CDT 2006

or use the dreaded SendKeys



"Doug Robbins - Word MVP" <dkr@REMOVECAPSmvps.org> wrote in message
news:OagY8BLzGHA.996@TK2MSFTNGP03.phx.gbl...
>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.
>
> --
> 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
>
> "Ed" <ed@pathagoras.com> wrote in message
> news:_WrJg.37803$ok5.37232@dukeread01...
>>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)
>>
>
>

HelmutWeber
Thu Aug 31 06:38:01 CDT 2006

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

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

Jay
Thu Aug 31 09:01:03 CDT 2006

Helmut Weber wrote:
> 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

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

--
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.

Roy
Fri Sep 01 03:10:44 CDT 2006


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

-Ed