|
code
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
DDE ProblemHi 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. "Waldy" <some***@microsoft.com>'s wild thoughts were released on Tue, 20 Nov 2007 11:27:10 -0000 bearing thefollowing fruit: Show quote >Hi there, Can I ask why you chose DDE?> 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. > -- Jan Hyde https://mvp.support.microsoft.com/profile/Jan.Hyde "Jan Hyde (VB MVP)" <StellaDrin***@REMOVE.ME.uboot.com> wrote in message You can ask although it doesn't really help. I am interfacing with a news:hfq5k3tijp7oa46s667iu6d7phc84104th@4ax.com... > Can I ask why you chose DDE? 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. "Waldy" <some***@microsoft.com>'s wild thoughts were released on Tue, 20 Nov 2007 16:23:11 -0000 bearing thefollowing fruit: > While I can't help you this extra information *is* useful to>"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. > 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 Jan Hyde (VB MVP) wrote:
Show quote > "Waldy" <some***@microsoft.com>'s wild thoughts were So, Jan, I guess you're saying (or implying) the OP would be better off doing a > 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 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 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: Well, that's not what I was getting at but it is very good>> "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 advice. >Actually, I remember DDE. I used it in a VB3 project to get a flexi-clock We only used DDE once, this was the only was to communicate>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. 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 2K or XP?
Make sure the Network DDE service is not disabled in services. -- Show quoteSteve Easton "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. > "Steve Easton" <ad***@95isalive.com> wrote in message Already checked that.news:OW2WnM5KIHA.5116@TK2MSFTNGP03.phx.gbl... > 2K or XP? > Make sure the Network DDE service is not disabled > in services. "Waldy" <some***@microsoft.com> wrote in message Do any of these help: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. > http://techsupt.winbatch.com/ts/T000001064F6.html http://msdn2.microsoft.com/en-us/library/aa171947(office.11).aspx Steve 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)
Show quote
"Waldy" <some***@microsoft.com> wrote in message You can use DDELastError() to help determine the error with the DDEInitiatenews: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. > 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 |
|||||||||||||||||||||||