Home » Developer & Programmer » Forms » Unable to create excel object for Excel 2007/Windows 7 (Oracle forms 10.1.2.3 and jre 1.6.0_16)
Unable to create excel object for Excel 2007/Windows 7 [message #470983] Wed, 11 August 2010 13:52 Go to next message
rivas24
Messages: 3
Registered: August 2010
Junior Member
Hello Every one ,
The below Oracle Forms code works fine for Excel 2003/Windows XP/IE6 but doesn't work for Excel 2007/Windows 7/IE8.

*********************
application := Client_OLE2.CREATE_OBJ('Excel.Application');

Client_OLE2.SET_PROPERTY(application,'Visible','TRUE');

workbooks := Client_OLE2.Get_Obj_Property(application, 'Workbooks');

args1 := Client_OLE2.create_arglist;
************************

There is no error while executing the form, by debugging we found that the control skips all the above code.

I'm using Oracle forms 10.1.2.3 and jre 1.6.0_16.

Would appreciate your help in providing a solution for the above issue.

Thanks,
Anbu

Report message to a moderator

Re: Unable to create excel object for Excel 2007/Windows 7 [message #470988 is a reply to message #470983] Wed, 11 August 2010 15:19 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I'm using Oracle forms 10.1.2.3 and jre 1.6.0_16.
Only Oracle V11.2 is certified on Windows 7.

Report message to a moderator

Re: Unable to create excel object for Excel 2007/Windows 7 [message #470989 is a reply to message #470988] Wed, 11 August 2010 15:28 Go to previous messageGo to next message
rivas24
Messages: 3
Registered: August 2010
Junior Member
As per this online oracle document

www.oracle.com/technology/products/forms/htdocs/10gR2/clientsod_forms10gR2.html

It say that Windows 7/IE 8.0 is supported with JRE1.6.0_16 and Oracle forms V10.1.2.3

Report message to a moderator

icon14.gif  Re: Unable to create excel object for Excel 2007/Windows 7 [message #471196 is a reply to message #470989] Thu, 12 August 2010 14:41 Go to previous message
rivas24
Messages: 3
Registered: August 2010
Junior Member
Finally found the solution


Disable UAC. Refer here:
windows.microsoft.com/en-US/windows-vista/Turn-User-Account-Control-on-or-off


After disabling UAC, it worked.

Report message to a moderator

Previous Topic: client_ole2.create_obj('Excel.Application) not working
Next Topic: Military time validation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 03:41:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.