Does anyone encounter this problem?

ccmin
ccmin Member Posts: 13
edited 2006-06-12 in NAV/Navision Classic Client
When I use Automation to export report to Excel, my client encounted this error once in a while.

"This message is for CAL programmer:

Could not invoke the member visible. The OLE control or Automation server returned an unknown error code."

Comments

  • ara3n
    ara3n Member Posts: 9,258
    The function visible is called at the end to display the excel file. If it is happening once in a while, then they are doing something different. See if you can replicate it.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • thaug
    thaug Member Posts: 106
    I've seen this happen with some of my users, but I could never really diagnose it. However, it may be because a user is possibly cancelling the Excel export generation, and then trying it again. Since the Visible property was never cleared out, it could possibly cause a problem. But, I've never really been able to fix it, and it only happens to certain users, so it very well may be a user problem.
    There is no data, only bool!
  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    Well, you can try to fix it by finding in table's 370 code CREATE(xlApp) and change it to CREATE(xlApp,True).

    This will create separate Excel process only for Navision, and of course uses twice memory :) but user working concurently with Excel will not interfere with Navision process.

    Regards,
    Slawek
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03

Categories