DDE Help

[bk1gti2]

I am making some progress with my Excel/VBA dde application. The only thing that has me hung up is poking into the sales journal.

channelnum = DDEInitiate("peachw", "BCS")
DDEPoke channelnum, "file=SALESJOURNAL,CLEAR", Cells(1, 1)
DDEPoke channelnum, "file=SALESJOURNAL,field=date", Cells(1, 2)
DDEPoke channelnum, "file=SALESJOURNAL,field=customer", Cells(1, 3)
DDEPoke channelnum, "file=SALESJOURNAL,field=firstdistribution", Range("Dist2")
DDEPoke channelnum, "file=SALESJOURNAL,SAVE", Cells(1, 1)

Dist 2 is a range in the spreadsheet where I have the fields for the distibution.

I get a:

DDE_ACK: Cannot accept invalid data

in the DDE conversation when it tries to poke the distibution.

[dringstrom]

This link will take to you the Peachtree web site, where you can download some example Excel source code: www.acctadv.com/go.mv?ID=dde

Alternatively, I have a fair amount of DDE information on my web site at www.acctadv.com/dde

[bk1gti2]

Thanks! I have been using both Peachtree's and your documentation. The info on your site is very useful and has helped me greatly. I just can't seem to poke the distiibution into Peachtree. I know that in exel the data must reside in a cell or cells. How do I reference the cells I want to use?

[dringstrom]

Originally posted by bk1gti2
How do I reference the cells I want to use?

Due to minimal documentation and few examples from Peachtree, it was a hard fought battle for me to master Peachtree's DDE implementation several years ago. Accordingly, I only offer direct assistance on DDE questions through www.acctadv.com/support.