Home » Developer & Programmer » Forms » Opening an Excel File through Forms
Opening an Excel File through Forms [message #159788] Tue, 21 February 2006 09:19 Go to next message
orahugo
Messages: 32
Registered: October 2005
Location: England
Member
Hello,

I've got an Excel file path as a field in the Form.

I.e. T:\A\b.xls

I've got a button on my form that I want to be able to click on and to display the file in a fresh Internet Explorer window.

So I've got my button and I'm using my WHEN-BUTTON-PRESSED trigger.

I've got my code as...

Web.Show_Document('http://'||name_in(:submissions_1.excel_file), '_blank');

:submissions_1.excel_file is the block.item that displays the filepath.

However, this doesn't seem to work. Any ideas why?

[Updated on: Tue, 21 February 2006 09:20]

Report message to a moderator

Re: Opening an Excel File through Forms [message #159836 is a reply to message #159788] Tue, 21 February 2006 18:58 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Please search this forum for 'excel'. This question has been asked previously.

When you find one that answers your question please give it a rating so that others can find it more easily.

David
Re: Opening an Excel File through Forms [message #159898 is a reply to message #159836] Wed, 22 February 2006 02:42 Go to previous messageGo to next message
orahugo
Messages: 32
Registered: October 2005
Location: England
Member
I've done a search, hence why I've asked the question. I've read the rules.

It seems all the searches I do for excel seem to give results about migrating data from Oracle to Excel. I simply want to open an excel file.
Re: Opening an Excel File through Forms [message #160024 is a reply to message #159898] Wed, 22 February 2006 16:12 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
We will have to build an entry for this in the Wiki or FAQ. Whatever.

Try searching this forum for 'exe', 'ora_ffi', 'dde', and 'host'. Different commands let you do different things to an excel file.

Also look at http://www.orafaq.com/forum/t/58701/67467/.

David
Previous Topic: how call lov to other lov
Next Topic: Abnormal termination
Goto Forum:
  


Current Time: Fri Sep 20 07:35:21 CDT 2024