Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Call a subroutine using variable subroutine name | Excel Discussion (Misc queries) | |||
How To Quit Subroutine from a called subroutine | Excel Programming | |||
Passing Constant Arguments to custom Subroutine & Functions | Excel Programming | |||
How to make userform disappear while called subroutine is running | Excel Programming | |||
Can't get out of selection? Assistance would be most appreciated... | New Users to Excel |