| Subject: | EXCEL Calculation |
| Posted by: | Teresa Cooper |
| Date: | Mon, 25 Jan 2010 |
How do I set excel calculation to manual from Delphi. I am connected to Excel and I can transfer data but my application is very slow. If I go into Excel and set the calcluation to Manual, my application runs much faster. I would like to handle changing the Excel application from within Delphi but I cannot seem to find the correct syntax to do it.
My connection into excel is called excelapp.
I have tried the following:
excelapp.calculation := xlManual;
excelapp.application.calculation := xlManual;
excelapp.calculation.xlManual := true;
Thank you in advance for your help.