Here's what I typically do for such things :
- Start the macro recorder
- Carry out the UI actions to make the change
- Stop the macro recorder and examine the marco code
- Add the relevant code in the Workbook Open event handler of my
template excel file.
For your requirement, the relevant code would be :
With Application
.Calculation = xlManual
End With
Hope this helps.
Sanjiv
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
