OraFAQ Forum: Forms » DDE vs Excel. How to access to a cell in the second sheet

Home » Developer & Programmer » Forms » DDE vs Excel. How to access to a cell in the second sheet (Forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DDE vs Excel. How to access to a cell in the second sheet [message #435466]

Wed, 16 December 2009 06:19

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.

Report message to a moderator

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

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

Report message to a moderator

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

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.

Report message to a moderator

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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Did you solve your problem?

David

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 02:41:51 CDT 2024