Home » Developer & Programmer » Forms » DDE vs Excel. How to access to a cell in the second sheet (Forms 6i)
DDE vs Excel. How to access to a cell in the second sheet [message #435466] Wed, 16 December 2009 06:19 Go to next message
serfraile
Messages: 18
Registered: November 2009
Junior Member
Hello everybody,

I need to know the value of a cell in excel that is not in the first sheet of the file. Do you know how to reference to the second sheet of an excel file?

I thought it was something like

DDE.REQUEST (docid, 'Sheet2!R19C4', buffer2, DDE.CF_TEXT, 1000);

but it doesn´t work.

Any ideas?

Thanks in advance.

Re: DDE vs Excel. How to access to a cell in the second sheet [message #435522 is a reply to message #435466] Wed, 16 December 2009 09:30 Go to previous messageGo to next message
serfraile
Messages: 18
Registered: November 2009
Junior Member
Hi again,

I've found that I can change the active sheet by using

dde.execute(convid, '[Workbook.Activate("Sheet2")]', 10000);

but when I try to access by using DDE.REQUEST, I can only have the values of the first sheet.

Please, i need your help; it's urgent.

Thanks
Re: DDE vs Excel. How to access to a cell in the second sheet [message #435927 is a reply to message #435522] Sat, 19 December 2009 01:48 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

I'm not sure of this, but you can try to do it on dde.initiate. Something like this: DDEInitiate ("Excel", "[Book1]Sheet1")

This is not tested, just try.
Re: DDE vs Excel. How to access to a cell in the second sheet [message #437544 is a reply to message #435522] Mon, 04 January 2010 23:53 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Did you solve your problem?

David
Previous Topic: direction of canvas
Next Topic: When calling a form from another form,got an error FRM-40108: No such form:formname
Goto Forum:
  


Current Time: Fri Dec 09 13:49:41 CST 2016

Total time taken to generate the page: 0.06923 seconds