Home » Developer & Programmer » Forms » How to navigate through worksheets using DDE
How to navigate through worksheets using DDE [message #270784] Fri, 28 September 2007 00:45 Go to next message
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.
Re: How to navigate through worksheets using DDE [message #272082 is a reply to message #270784] Thu, 04 October 2007 00:09 Go to previous messageGo to next message
anisam10674
Messages: 18
Registered: March 2007
Junior Member
Any suggestions on this would be of great help.
Re: How to navigate through worksheets using DDE [message #320409 is a reply to message #272082] Thu, 15 May 2008 01:07 Go to previous messageGo to next message
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

Re: How to navigate through worksheets using DDE [message #679791 is a reply to message #270784] Sat, 28 March 2020 07:13 Go to previous messageGo to next message
ahmadk1974
Messages: 1
Registered: March 2020
Location: Lebanon
Junior Member
Hello
please, did you get the solution of this problem?
I need it also

Re: How to navigate through worksheets using DDE [message #679792 is a reply to message #679791] Sat, 28 March 2020 10:20 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Did you try the solution in the previous post and its url?

Previous Topic: ORACLE 6i Forms work flow Approval
Next Topic: 12C forms and reports recommended book(s)
Goto Forum:
  


Current Time: Thu Mar 28 07:19:43 CDT 2024