Could not invoke the member visible

Albertvh

Hi,

I'm trying to export the Account Schedule to excel when i get the following error message

This message is for C/AL Programmers.
Could not invoke the member Visible. The OLE control or Automation Server
returned an unknow error code

Nav 4 native db. no SP
Client is running on Vista


TIA

Marije_Brummel

Maybe you are running a version of excel that is not supported?

What code do you see when you run the debugger without activating the breakpoints?

Albertvh

Hi Mark,

Thanks for the reply.
Excel version is Excel 2007 (12.0.6514.5000) SP2 MSO (12.0.6425.100)

The debugger stops when the report ends and tries to give the user control from the excel buffer table

GiveUserControl()
XlApp.Visible(TRUE);

It does run on other client machines but I don't know if they are running on vista.

Thanks

Albert

Marije_Brummel

Maybe it would be a good idea to compare the excel buffer table in your database to a 5SP1 database. Maybe they have changed something in a newer version to support this combination.

Albertvh

Hi Mark,

Thanks for your help will check this out.


Albert