OraFAQ Forum: Forms » How to navigate through worksheets using DDE

Home » Developer & Programmer » Forms » How to navigate through worksheets using DDE

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

How to navigate through worksheets using DDE [message #270784]

Fri, 28 September 2007 00:45

anisam10674
Messages: 18
Registered: March 2007

Junior Member

I have an excel file with 3 different worksheets. There is a textbox wherein user will specify any one of the three worksheets name. When I use the DDE context to open the excel file, usually the last selected worksheet gets opened. What I would like to do is open that worksheet whose name is specified by user through the textbox on the form.

Report message to a moderator

Re: How to navigate through worksheets using DDE [message #272082 is a reply to message #270784]

Thu, 04 October 2007 00:09

anisam10674
Messages: 18
Registered: March 2007

Junior Member

Any suggestions on this would be of great help.

Report message to a moderator

Re: How to navigate through worksheets using DDE [message #320409 is a reply to message #272082]

Thu, 15 May 2008 01:07

jale
Messages: 15
Registered: May 2008
Location: TURKEY

Junior Member

I think with DDE you may do it.

DDE.App_Focus(AppID);

and then

DDE.Execute(AppID, '[calculate.now()]', 1000);

you must search Excel VBA code to set focus on sheet2 sheet3 like

calculate.now()

Also..

http://forums.oracle.com/forums/thread.jspa?messageID=2475426

And ole2 allows you to manage worksheets

[Edit MC: fix url]

[Updated on: Sat, 28 March 2020 10:19] by Moderator

Report message to a moderator