DDEInitiate question

[SeraphAP]

I'm using excel and VBA to grab data from an external app via DDE. I have it working well, BUT the first time the code connects to the external app(IBM Personall Communicator) I get the dialog box asking for a data source, which is always the first on the list. My end users may not understand this part. The datasource is always the same, and I'm initating the correct channel. The problem doesn't occur after the first time the external app is connected to; however, if the external app is restarted and I connect again, the "select data source" window comes up again.

Is there a way to specificy which data source you connect to by VBA code? I thought the app name and topic were enough…

code isn't anything special, but…

Dim lngWorkManagerChannel As Long
 lngWorkManagerChannel = Application.DDEInitiate("IBM327032", "SessionA") 'open channel to WorkManager

'  more code here

 DDETerminate lngWorkManagerChannel   'close channel

 

[RoryA]

Does it help if you use:

lngStart = Application.DDEInitiate("IBM327032", "System")

before your Session code?

 

[SeraphAP]

Doesn't help

Any other ideas?

 

[RoryA]

Afraid not - I don't work with DDE myself.