export from excel to an application with visual basic

[bencnu]

I am trying to export information from a cell to and application. I know you can export info to a text file,

channelNumber = Application.DDEInitiate( _
app:="WinWord", _
topic:="C:\Program Files\Microsoft Office\Office10\test.doc&quot
Set rangeToPoke = Worksheets("Sheet1&quot.Range("A1&quot
Application.DDEPoke channelNumber, "\StartOfDoc", rangeToPoke
Application.DDETerminate channelNumber

But can i export cell a1 to a program like calculator?

 

[BrainB]

Have a look at the Shell command (and SendKeys) in VB Editor Help.
Could be just what you want.

Regards
BrianB
** Let us know if you get something that works !
================================

 

[bencnu]

thank you for the advice, but i still can't seem to get it working.....