Home » Developer & Programmer » Forms » Open XML file with Excel from Forms (Oracle Forms 10g/11g)
Open XML file with Excel from Forms [message #620435] Fri, 01 August 2014 07:09 Go to next message
Grir
Messages: 3
Registered: August 2014
Location: Estonia
Junior Member
Hi,

I need to open XML file from local PC with Excel, something like:
CLIENT_HOST( 'cmd /c <excel_path>\Excel.exe <my_file_path_and_name>' );
The problem is I don't want to specify excel_path, but
CLIENT_HOST( 'cmd /c <my_file_path_and_name>' );
works fine if extension is XLS - and I have XML.

Thanks in advance for any good solution!
Re: Open XML file with Excel from Forms [message #620438 is a reply to message #620435] Fri, 01 August 2014 07:44 Go to previous messageGo to next message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is Windows, right? Try to associate XML extension with MS Excel and see what happens.
Re: Open XML file with Excel from Forms [message #620441 is a reply to message #620438] Fri, 01 August 2014 07:57 Go to previous messageGo to next message
Grir
Messages: 3
Registered: August 2014
Location: Estonia
Junior Member
O, no! I can't do that Sad
Many people are using this software, and XML should be associated as usual ...
Re: Open XML file with Excel from Forms [message #620472 is a reply to message #620441] Fri, 01 August 2014 15:24 Go to previous messageGo to next message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As you don't want to invoke Excel nor associate the XML extension with it, I don't see another way. Someone else might, though. Be patient until that "someone" comes here.
Re: Open XML file with Excel from Forms [message #620811 is a reply to message #620472] Wed, 06 August 2014 04:50 Go to previous messageGo to next message
Grir
Messages: 3
Registered: August 2014
Location: Estonia
Junior Member
For those who may be interested - I found a solution that works:

CLIENT_HOST( 'cmd /c start excel.exe <xml_file_with_path>');
Re: Open XML file with Excel from Forms [message #620813 is a reply to message #620811] Wed, 06 August 2014 04:59 Go to previous message
cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester
Senior Member
thanks for letting us know
Previous Topic: SQL NOT TO COMMIT
Next Topic: calling a form within a form
Goto Forum:
  


Current Time: Fri Apr 26 16:26:27 CDT 2024