Question posted 2008 · +7 upvotes
I’m trying to automate some stuff in MS Excel. When I try to set the Calculation property I get the following error message: ‘Unable to set the Calculation property of the Application class’
I believe this property should be settable.
Any advice appreciated!
Accepted answer +6 upvotes
Googling produces this suggestion:
You need to have a open workbook, ie
xl.Workbooks.Add
xl.Calculation = xlCalculationManual
Top excel Q&A (6)
- Shortcut to Apply a Formula to an Entire Column in Excel +335 (2011)
- How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
- Convert xlsx to csv in linux command line +96 (2012)
- How to create a link inside a cell using EPPlus +50 (2011)
- IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
- T-SQL: Export to new Excel file +44 (2012)
excel solutions on this site
.