Could not invoke the member visible

Albertvh
Albertvh Member Posts: 516
edited 2010-01-06 in NAV/Navision Classic Client
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

Comments

  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    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?
    Marije Brummel | Freelance Business Central Specialist
  • Albertvh
    Albertvh Member Posts: 516
    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
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    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.
    Marije Brummel | Freelance Business Central Specialist
  • Albertvh
    Albertvh Member Posts: 516
    Hi Mark,

    Thanks for your help will check this out.


    Albert

Categories