getting 'xlCalculationManual' to work in lotus script 1

[domino1352]

I am trying to speed up the creation of a spread sheet but when I try to turn of the automatic calculation it errors out on me


I have tried the following lines
xl.Calculation = xlCalculationManual
xlSheet.application.Calculation = "xlCalculationManual"


here is a code snippet
Set xl = CreateObject("Excel.application&quot
set xlWbk = xl.Workbooks.Add
Set xlSheet = xlWbk.Worksheets(1)
Call xlSheet.Activate
xl.screenupdating = False
xl.Calculation = "xlCalculationManual"
On Error Goto errorHandler

 

[ploeryan]

Hi,

Try
xlsheet.enablecalculation = false 'turns off autocalc

Regards.

 

[Nikita6003]

and if you're using xlConstants sunch as xlCalculationmanual DON'T surround them with quotes - that way you're turning hem into strings which xl won't compile into the correct constant

HTH!

Cheers
Nikki
;-)

 

[domino1352]

thanks Ploeryan and Nikki the
xlsheet.enablecalculation = false 'turns off autocalc
statement worked (Although I didnot see a huge jump in speed for SS creation )

Thanks again for your prompt replys