Does anyone encounter this problem?

ccmin

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."

ara3n

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.

thaug

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.

Slawek_Guzek

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