OraFAQ Forum: Forms » Making Excel visible

Home » Developer & Programmer » Forms » Making Excel visible

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Making Excel visible [message #181100]

Thu, 06 July 2006 14:47

orate
Messages: 16
Registered: September 2005

Junior Member

I am using Forms 4.5 and Excel 97.

The following code

application := ole2.create_obj('Excel.Application');
--- export data to Excel here
ole2.set_property(application, 'Visible', 'True');

doesn't show Excel. Why?
(The exportation works fine).

Report message to a moderator

Re: Making Excel visible [message #181142 is a reply to message #181100]

Fri, 07 July 2006 01:05

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please search this forum for 'excel' or 'ole2'. There are plenty of worked examples.

David

Report message to a moderator

Re: Making Excel visible [message #181311 is a reply to message #181100]

Sat, 08 July 2006 09:00

orate
Messages: 16
Registered: September 2005

Junior Member

The problem fixed changing 'True' by 1.

ole2.set_property(application, 'Visible', 1);

Report message to a moderator

Re: Making Excel visible [message #182358 is a reply to message #181311]

Fri, 14 July 2006 08:02

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Taking the quotes off the last parameter probably would have worked too.

David

Report message to a moderator

Previous Topic:	moving a frame
Next Topic:	How "copy from " SQL command working in forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 08:23:15 CDT 2024