Running DDE functions within VBA subroutine - Any assistance appreciated
 

This may be either stupid or obvious but here goes...

Is there any way to run a DDE function within a subroutine and return
the results to the subroutine without actually assigning the DDE
function to the cell formula attribute?

Thanks
Jeff Stryer

Running DDE functions within VBA subroutine - Any assistance appreciated
 

Jeff,
There are various DDE methods available through the application object.
<From Help
DDEInitiate Method
Opens a DDE channel to an application.

expression.DDEInitiate(App, Topic)

expression Optional. An expression that returns an Application object.
App Required String. The application name.
Topic Required String. Describes something in the application to which
you're opening a channel - usually a document of that application.
</From Help

Couldn't say if this is still support in XL 2007.

NickHK

wrote in message
oups.com...
This may be either stupid or obvious but here goes...

Is there any way to run a DDE function within a subroutine and return
the results to the subroutine without actually assigning the DDE
function to the cell formula attribute?

Thanks
Jeff Stryer