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"
Set rangeToPoke = Worksheets("Sheet1"
.Range("A1"
Application.DDEPoke channelNumber, "\StartOfDoc", rangeToPoke
Application.DDETerminate channelNumber
But can i export cell a1 to a program like calculator?
channelNumber = Application.DDEInitiate( _
app:="WinWord", _
topic:="C:\Program Files\Microsoft Office\Office10\test.doc"
Set rangeToPoke = Worksheets("Sheet1"
Application.DDEPoke channelNumber, "\StartOfDoc", rangeToPoke
Application.DDETerminate channelNumber
But can i export cell a1 to a program like calculator?