OLE Control or Automation server returned error(HRESULT)

nikeman77
nikeman77 Member Posts: 517
edited 2012-04-23 in NAV/Navision Classic Client
hi all,

anyone ever faced this error message?

"this message is for C/AL Programmers:
an exception was raised in method name. the OLE Control or Automation server returned error(HRESULT) -2147352567.
the component did not provide the exception description."

Answers

  • Reinhard
    Reinhard Member Posts: 249
    Yes.

    I get it for example if I am using Excel automation and have it open on my desktop AND I have a cell selected for editing.

    And in the post I just put up:
    viewtopic.php?f=23&t=52554

    Either way it's hard to tell without additional info on what the code that generated the error is trying to do.
    Oztera
  • nikeman77
    nikeman77 Member Posts: 517
    hi all,

    got it resolved already, basically i call create excel codes twice, one on the reports.ini, second one on dataitem post data item... ](*,)
  • kattelbach
    kattelbach Member Posts: 1
    I had the same error message " ... (HRESULT) -2147352567 ... " trying to export data from DynamicsNAV 4SP2 to Excel 2010.

    It may sound stupid but it was caused bij the textstring '=== ChapterHeader ==='

    Once I replaced '=== ChapterHeader ===' by '--- ChapterHeader ---' the problem was solved.

    Cheers, Johan 8) 8)
  • Reinhard
    Reinhard Member Posts: 249
    Makes sense... formulas in excel start with a = sign so '====Chapter Header====' is basically an invalid formula.
    You can put a ' at the beginning to indicate to excel that it is not a formula, just text.
    Oztera

Categories