What does it mean: Method Calculation of object “Application” failed

Jiurasic · Mar 30, 2009

Hello to All!
I have two Excel Programs. One of it launch another with:

Code:

  Set XlChpr = CreateObject("Excel.application")
  XlChpr.Visible = True
  XlChpr.Workbooks.Open Range("path").Text

Then, when the second program starts displays window ( a headband). After this window closes there is a code:

Code:

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
   Application.Calculation = xlAutomatic
End Sub

At this line sometimes program shows me such a mistake: Method Calculation of ob-ject “Application” failed. What does it mean?

xenou · Mar 31, 2009

its possible with late binding (createobject) you need to use the integer value instead of the named constant -

Code:

application.calculation = -4105

Not sure. Maybe put the line in a standard module instead of a userform query close event.