dderequest with excel

TommyJ · Post by **TommyJ** » Tue Sep 30, 2003 9:02 pm

alright, this will be simple
here's my code:

setfocus>Excel*
dderequest>Excel,c:\temp\pay8.xls ,R1C1, ret, 10
ddepoke>Excel, C:\temp\pay8.xls, R10C1, ret
ddepoke>Excel, C:\temp\pay8.xls, R11C1, %ret%

all i'm trying to do is get dderequest to work for me, but when i check to see if it's pulling the right data (with the ddepoke) it outputs
"ret" and "%ret%" instead of the value in the cell i'm trying to store...

what am i doin' wrong?

Bob Hansen · Post by **Bob Hansen** » Wed Oct 01, 2003 4:23 am

I think you need to remove some "space" characters:

setfocus>Excel*
dderequest>Excel,c:\temp\pay8.xls ,R1C1, ret, 10
ddepoke>Excel, C:\temp\pay8.xls, R10C1, ret
ddepoke>Excel, C:\temp\pay8.xls, R11C1, %ret%

TommyJ · Post by **TommyJ** » Wed Oct 01, 2003 2:18 pm

thanks, i finally got this to work for me

let>ret=test
setfocus>Excel*
dderequest>Excel,c:\temp\pay8.xls,R1C1,ret,10
ddepoke>Excel,C:\temp\pay8.xls,R10C1,%ret%