Running DDE functions within VBA subroutine - Any assistance appreciated

[jeffstryer]

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

 

[NickHK]

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