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 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..

forums.oracle.com/forums/thread.jspa?messageID=2475426&#2475426

And ole2 allows you to manage worksheets

[Updated on: Thu, 15 May 2008 01:45]

Report message to a moderator

Previous Topic: sort data in no DB block
Next Topic: Radio button to select current row in multirecord block -6i
Goto Forum:
  


Current Time: Fri Dec 09 19:15:40 CST 2016

Total time taken to generate the page: 0.09567 seconds