Running DDE functions within VBA subroutine - Any assistance appreciated

  • Thread starter Thread starter jeffstryer
  • Start date Start date
J

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