2 replies to this topic

[Xia Mey]

Dear all

 

Here is a non AHK right?

 

So could someone help me with this issue please. I tried weeks but i got nothing. I am trying to connect Excel to Peachtree

Dim ChannelNumber As Long
Dim Dataa As Variant

Application.DisplayAlerts = False
ChannelNumber = Excel.Application.DDEInitiate("peachw", "COMPANY")
Application.DisplayAlerts = True

Application.DDEPoke ChannelNumber, "file=generaljournal,clear,field=Date", "01/01/15"

Application.DDETerminate ChannelNumber

No idea why DEEPoke doesn't work.

 

Appreciate for your help

[kon]

According to this page, DDE is no longer supported by Sage 50 Accounting (formerly Peachtree). They apparently do have a COM SDK though.

[Xia Mey]

Yes. wasted several weeks.
Thank you very much