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.

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.com

-------------------------------------------------------------------------
          Montréal - Ottawa - Toronto - Winnipeg
Tel : 514.842-7995                 Fax : 514.842-1602

-------------------------------------------------------------------------
Received on Sat Apr 25 1998 - 02:55:25 CEST

Original text of this message