Home All Groups Group Topic Archive Search About
Author
20 Nov 2007 11:27 AM
Waldy
Hi there,
               I am just trying to run a DDE example.  I have created a
project, included Excel as a reference and entered the following lines of
code:

    Dim chan As Integer

    chan = DDEInitiate("Excel", "System")

    DDEPOKE chan, "Sheet1, R1C1", "Test"

    DDETerminate chan

However, the DDEInitiate call just hangs.  What is the problem?  I've also
tried using a file name instead of "System".  Excel is loaded in memory if
you look in Task Manager.

Author
20 Nov 2007 2:06 PM
Jan Hyde (VB MVP)
"Waldy" <some***@microsoft.com>'s wild thoughts were
released on Tue, 20 Nov 2007 11:27:10 -0000 bearing the
following fruit:

Show quote
>Hi there,
>               I am just trying to run a DDE example.  I have created a
>project, included Excel as a reference and entered the following lines of
>code:
>
>    Dim chan As Integer
>
>    chan = DDEInitiate("Excel", "System")
>
>    DDEPOKE chan, "Sheet1, R1C1", "Test"
>
>    DDETerminate chan
>
>However, the DDEInitiate call just hangs.  What is the problem?  I've also
>tried using a file name instead of "System".  Excel is loaded in memory if
>you look in Task Manager.
>

Can I ask why you chose DDE?
--
Jan Hyde

https://mvp.support.microsoft.com/profile/Jan.Hyde
Author
20 Nov 2007 4:23 PM
Waldy
"Jan Hyde (VB MVP)" <StellaDrin***@REMOVE.ME.uboot.com> wrote in message
news:hfq5k3tijp7oa46s667iu6d7phc84104th@4ax.com...
> Can I ask why you chose DDE?

You can ask although it doesn't really help.  I am interfacing with a
telephony application and for some reason they always seem to use DDE.  I
want to write a test application that uses DDEPoke to emulate the telephony
application.  I have to create a DDE server, which I know how do.  What I
don't know how to do is emulate the DDEPoke that is going to be coming from
the telephony app to my DDE server application.
Author
20 Nov 2007 5:06 PM
Jan Hyde (VB MVP)
"Waldy" <some***@microsoft.com>'s wild thoughts were
released on Tue, 20 Nov 2007 16:23:11 -0000 bearing the
following fruit:

>
>"Jan Hyde (VB MVP)" <StellaDrin***@REMOVE.ME.uboot.com> wrote in message
>news:hfq5k3tijp7oa46s667iu6d7phc84104th@4ax.com...
>> Can I ask why you chose DDE?
>
>You can ask although it doesn't really help.  I am interfacing with a
>telephony application and for some reason they always seem to use DDE.  I
>want to write a test application that uses DDEPoke to emulate the telephony
>application.  I have to create a DDE server, which I know how do.  What I
>don't know how to do is emulate the DDEPoke that is going to be coming from
>the telephony app to my DDE server application.
>

While I can't help you this extra information *is* useful to
know. You never know when someone will come along that has
done *exactly* what you are doing.



--
Jan Hyde

https://mvp.support.microsoft.com/profile/Jan.Hyde
Author
20 Nov 2007 9:35 PM
argusy
Jan Hyde (VB MVP) wrote:
Show quote
> "Waldy" <some***@microsoft.com>'s wild thoughts were
> released on Tue, 20 Nov 2007 16:23:11 -0000 bearing the
> following fruit:
>
>> "Jan Hyde (VB MVP)" <StellaDrin***@REMOVE.ME.uboot.com> wrote in message
>> news:hfq5k3tijp7oa46s667iu6d7phc84104th@4ax.com...
>>> Can I ask why you chose DDE?
>> You can ask although it doesn't really help.  I am interfacing with a
>> telephony application and for some reason they always seem to use DDE.  I
>> want to write a test application that uses DDEPoke to emulate the telephony
>> application.  I have to create a DDE server, which I know how do.  What I
>> don't know how to do is emulate the DDEPoke that is going to be coming from
>> the telephony app to my DDE server application.
>>
>
> While I can't help you this extra information *is* useful to
> know. You never know when someone will come along that has
> done *exactly* what you are doing.
>
>
>
> --
> Jan Hyde
>
> https://mvp.support.microsoft.com/profile/Jan.Hyde

So, Jan, I guess you're saying (or implying) the OP would be better off doing a
google groups search on his subject BEFORE asking the degenerates (bg) who lurk
in this newsgroup

Actually, I remember DDE. I used it in a VB3 project to get a flexi-clock
program to get data from a central PC. I couldn't be bothered to do a re-write
after I upgraded to VB5, so it died. Pity - I could now sell it to several
government departments.

Argusy
Author
21 Nov 2007 9:03 AM
Jan Hyde (VB MVP)
argusy <arg***@slmember.on.net>'s wild thoughts were
released on Wed, 21 Nov 2007 08:05:47 +1030 bearing the
following fruit:

Show quote
>Jan Hyde (VB MVP) wrote:
>> "Waldy" <some***@microsoft.com>'s wild thoughts were
>> released on Tue, 20 Nov 2007 16:23:11 -0000 bearing the
>> following fruit:
>>
>>> "Jan Hyde (VB MVP)" <StellaDrin***@REMOVE.ME.uboot.com> wrote in message
>>> news:hfq5k3tijp7oa46s667iu6d7phc84104th@4ax.com...
>>>> Can I ask why you chose DDE?
>>> You can ask although it doesn't really help.  I am interfacing with a
>>> telephony application and for some reason they always seem to use DDE.  I
>>> want to write a test application that uses DDEPoke to emulate the telephony
>>> application.  I have to create a DDE server, which I know how do.  What I
>>> don't know how to do is emulate the DDEPoke that is going to be coming from
>>> the telephony app to my DDE server application.
>>>
>>
>> While I can't help you this extra information *is* useful to
>> know. You never know when someone will come along that has
>> done *exactly* what you are doing.
>>
>>
>>
>> --
>> Jan Hyde
>>
>> https://mvp.support.microsoft.com/profile/Jan.Hyde
>
>So, Jan, I guess you're saying (or implying) the OP would be better off doing a
>google groups search on his subject BEFORE asking the degenerates (bg) who lurk
>in this newsgroup

Well, that's not what I was getting at but it is very good
advice.

>Actually, I remember DDE. I used it in a VB3 project to get a flexi-clock
>program to get data from a central PC. I couldn't be bothered to do a re-write
>after I upgraded to VB5, so it died. Pity - I could now sell it to several
>government departments.

We only used DDE once, this was the only was to communicate
with a product we were using at the time. It was horrible,
luckily said product moved to a com interface.

I don't remember anything about DDE now so unfortunately
can't help the OP.


--
Jan Hyde

https://mvp.support.microsoft.com/profile/Jan.Hyde
Author
20 Nov 2007 4:33 PM
Steve Easton
2K or XP?
Make sure the Network DDE service is not disabled
in services.


--

Steve Easton


Show quote
"Waldy" <some***@microsoft.com> wrote in message news:OkEVLh2KIHA.4272@TK2MSFTNGP05.phx.gbl...
> Hi there,
>               I am just trying to run a DDE example.  I have created a project, included Excel as a
> reference and entered the following lines of code:
>
>    Dim chan As Integer
>
>    chan = DDEInitiate("Excel", "System")
>
>    DDEPOKE chan, "Sheet1, R1C1", "Test"
>
>    DDETerminate chan
>
> However, the DDEInitiate call just hangs.  What is the problem?  I've also tried using a file name instead
> of "System".  Excel is loaded in memory if you look in Task Manager.
>
Author
20 Nov 2007 4:44 PM
Waldy
"Steve Easton" <ad***@95isalive.com> wrote in message
news:OW2WnM5KIHA.5116@TK2MSFTNGP03.phx.gbl...
> 2K or XP?
> Make sure the Network DDE service is not disabled
> in services.

Already checked that.
Author
21 Nov 2007 8:56 AM
Steve Barnett
"Waldy" <some***@microsoft.com> wrote in message
news:u0LtiS5KIHA.3848@TK2MSFTNGP05.phx.gbl...
>
> "Steve Easton" <ad***@95isalive.com> wrote in message
> news:OW2WnM5KIHA.5116@TK2MSFTNGP03.phx.gbl...
>> 2K or XP?
>> Make sure the Network DDE service is not disabled
>> in services.
>
> Already checked that.
>

Do any of these help:

http://techsupt.winbatch.com/ts/T000001064F6.html

http://msdn2.microsoft.com/en-us/library/aa171947(office.11).aspx

Steve
Author
20 Nov 2007 6:58 PM
Paul Clement
On Tue, 20 Nov 2007 11:27:10 -0000, "Waldy" <some***@microsoft.com> wrote:

¤ Hi there,
¤                I am just trying to run a DDE example.  I have created a
¤ project, included Excel as a reference and entered the following lines of
¤ code:
¤
¤     Dim chan As Integer
¤
¤     chan = DDEInitiate("Excel", "System")
¤
¤     DDEPOKE chan, "Sheet1, R1C1", "Test"
¤
¤     DDETerminate chan
¤
¤ However, the DDEInitiate call just hangs.  What is the problem?  I've also
¤ tried using a file name instead of "System".  Excel is loaded in memory if
¤ you look in Task Manager.
¤

Are you using one of the Office apps to run this code? VB 6.0 doesn't support these functions.

In VB 6.0 you need to use a Form control (such as a Label or TextBox) for DDE.


Paul
~~~~
Microsoft MVP (Visual Basic)
Author
20 Nov 2007 7:30 PM
Ralph
Show quote
"Waldy" <some***@microsoft.com> wrote in message
news:OkEVLh2KIHA.4272@TK2MSFTNGP05.phx.gbl...
> Hi there,
>                I am just trying to run a DDE example.  I have created a
> project, included Excel as a reference and entered the following lines of
> code:
>
>     Dim chan As Integer
>
>     chan = DDEInitiate("Excel", "System")
>
>     DDEPOKE chan, "Sheet1, R1C1", "Test"
>
>     DDETerminate chan
>
> However, the DDEInitiate call just hangs.  What is the problem?  I've also
> tried using a file name instead of "System".  Excel is loaded in memory if
> you look in Task Manager.
>

You can use DDELastError() to help determine the error with the DDEInitiate
call - assuming it eventually returns that is. <g>

With some libraries/apps if the service app isn't open, currently
unavailable, or with some security settings - it will send a request for
permission to open a DDE connection usually through a messagebox/dialog. Is
it possiblity putting up a dialog somewhere and you are missing it?

How long have you let it "hang" before giving up?

One thing you might try is creating a simple VB DDE server. Just a simple
form with a TextBox and set the DDE properties. You can use it to make sure
everything in your app is working.

-ralph

AddThis Social Bookmark Button