OLE Exception Error RRS feed

  • Question

  • We have a VBA application which processes with Excel.

    This application is performed several times per hour.

    And it takes a few seconds to complete one application processing.

    After completion, Excel gets closed.

    In normal situation, there is no problem.

    However "OleDispatch Exception" error is returned occasionally(per few months).

    We are not sure what is the trigger of this error.

    When we get the error, we suspect Excel gets in something trouble.

    Because the same error is returned when calling Excel.

    Once getting in trouble, then the same error occurs every time by calling Excel until restarting PC.

    After PC is restarted, problem is solved temporarily.

    Friday, December 21, 2018 9:52 PM