ole function between oracle developper 2000 ole2 package and Excel 97
From: Nicolas Rancourt <nicolas.rancourt_at_sympatico.ca>
Date: Sat, 25 Apr 1998 00:55:25 GMT
Message-ID: <01bd6fe4$a8e8d620$adf1acce_at_default>
Hi.
Date: Sat, 25 Apr 1998 00:55:25 GMT
Message-ID: <01bd6fe4$a8e8d620$adf1acce_at_default>
Hi.
I want to change the Calculation property of excel sheet to Manual
value and Automatic value via oracle ole2 package in forms 4.5.
I already create ole2 object and I'm able to change sheetsinworksheet
property with
ole2.set_property(global.application,'sheetsinworksheet',4)
I want to use the same function to change Calculation value.
ole2.set_property(global.application,'Calculation','xlmanual' or ???)
This is the problem, the value of Calculation property doesn't seem
work.
Thank for all solutions of my problem.
nicolas.rancourt_at_sympatico.ca Le Groupe Progestic Conseillers en gestion et en informatique http://www.groupe-progestic.comMontréal - Ottawa - Toronto - Winnipeg
-------------------------------------------------------------------------
Tel : 514.842-7995 Fax : 514.842-1602Received on Sat Apr 25 1998 - 02:55:25 CEST
-------------------------------------------------------------------------