DDEPoke UserID/Password

[lebisol]

Hello People!
Please forgive my ignorance but this my 1st attemp to pull data from PT using DDE...and using DDE in general.
After looking through http://www.peachtree.com/downloads/ddeman.pdf
manual I got the sample for password poke but I had no luck. partially since no one ever mentioed user name in this combo and my (lack of) excell skils.

My best attemp was with Excell 2002:

-------------------A--------------------------|----------------B....
1 = Initiate("peachw", "BCS")
2 = DEFINE.NAME("ChnlNum",A1)
3 pass
4 user
5 = DEFINE.NAME("varPASS",A3)
6 = DEFINE.NAME("varUSR",A4)
7 = POKE(ChnlNum,"UserID",varUSR,"Password",VarPass)
8 = REQUEST(ChnlNum,"file=Company,field=name")
9 = PeachW|BCS!'file=lineitem,range=AVRY-10100,AVRY-10100,Field=key'
10 =POKE(ChnlNum,"file=lineitem,range=AVRY-10100,AVRY-10100,Field=key")
------------------------------------------------|---------------B.....


But I had no luck.... A9 returns "You are not allowed to access..."


I would really like to learn more about DDE and peachtree but after talking to PeachTree support...well....their support was summed up to:
"Yeah, peachtree does support DDE...have a nice day".
The more I read about PT and DDE the more options and custom remporting I see available....why is this NOT promoted by PT?

If any of you have books,links or material that can help I would apprechiate some pointers. I am aware of PAWCOM but I am not in position to "re-purchase peachtree".
Thank you all!

[dringstrom]

I offer some free DDE tips at http://www.accountingadvisors.com/generaldde.shtml, including one that may get you on the right track.

[lebisol]

Hi storm!
:) that is exactly where I got the whole idea of user\pass but I am not sure of format as PT suggests only a password use while there is not mentioning about userID.
Are u suggesting that "password" should thread as one string of
vaLOGIN="username\password" where I can store it some cell as
"joe\joepass"
The script above didn't work...the company name never gets pasted?
Thank you for all the help!

[dringstrom]

Yes, you're on the right track now. I'm sorry to be cryptic, but I gained all of my DDE knowledge the hard way, and so there's only limited amounts of info that I'm willing to give a way for free.

[lebisol]

:)
It's quite all right, I definetly understand the DDE PAIN, hence this is what you do for living.
Thanx for the tips.
I will try looking over PT samples provided......I fear VB loops and conditions as I have very little experience.
Anyhow, I apprechiate the effort!