Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DDE links in V5.7

Status
Not open for further replies.

davidV

Technical User
Nov 22, 2000
6
0
0
GB
Having successfully opened a DDE link to EXCEL (Office 97 version) with x.initiate("EXCEL","barcs22a.xls"), can anyone tell me why x.peek("a3") and x.poke("a3","xyz") do not work - nor with any other cell reference. The link is definately established as x.execute(......) works.
 
The problem withyour code for x.poke is the reference to the cell in excel. The reference should be "R1C1" for Row 1 Cell 1 rather than "A1". If you need additional info or sample code let me know.

Randal
 
Thank you Rriley

I actually got the answer a little while ago via the compuserve dbase forum, but thank you for your respnse anyway.

davidV
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top