mibuso.com
Home› NAV/Navision Classic Client

Error while exporting report data to excel

poppinspoppins Member Posts: 647
edited 2014-05-23 in NAV/Navision Classic Client
Hi everyone,
I am trying to export some report data to excel.
I used the table 370 Excel buffer and specially the function AddColumn
When I run the report, I get the following error:
This message is for C/AL programmers:
Could not invoke the member Range. The OLE control or Automation server returned an unknown
error code.
I am using Nav 20009 R2 Classic, SQL Server 2008 R2, Office 2013 Professional.
What seems to be the problem?
Thanks in advance :)

Comments

  • geordiegeordie Member Posts: 655
    What Office version are you using? With NAV 2009 32-bit Office installation is recommended.
    Does a "simple" data export work fine?
    * Daniele Rebussi * | * Rebu NAV Diary *
  • KeeperRUKeeperRU Member Posts: 58
    Can you compile t370?
    I think Excel 2013 has different Automation Server... and if ALL users on Excel 2013 - You should edit t370, find all unknown automation servers - and change for Excel 2013 Automation Server.
  • poppinspoppins Member Posts: 647
    KeeperRU wrote:
    Can you compile t370?
    I think Excel 2013 has different Automation Server... and if ALL users on Excel 2013 - You should edit t370, find all unknown automation servers - and change for Excel 2013 Automation Server.
    You were right, I found many unknown automation servers....
    but how can I replace them with Excel 2013 automation server?
    I tried to look for it in the list of the different automations (I clicked the button near Unknown Automation Server.Application and accessed the list of automations, no Excel 2013 automation server found)...
    I tried to copy the value I found in table 370 in NAV 2013 but it didn't work....
    What shall I do????
    PS: I used to work with Excel 2013 and NAV 2009 just fine, I don't know what happend :mrgreen:
  • KeeperRUKeeperRU Member Posts: 58
    I think you need to find "Microsoft Excel 15.0 Object Library" in list.

    It's strange that all work fine earlier... how about another users?
    If you change t370 Automation Server it can broke other users Excel Integration (backup t370 object).

    Try to reinstall Excel 2013, if there is no "Microsoft Excel Object Library" in Automation list.

    Maybe earlier you have Excel 2007\2010 and then install 2013 over it, and all was fine.
    And now you uninstall all of it, and install ONLY 2013. That may cause all your trouble.
  • poppinspoppins Member Posts: 647
    KeeperRU wrote:
    I think you need to find "Microsoft Excel 15.0 Object Library" in list.

    It's strange that all work fine earlier... how about another users?
    If you change t370 Automation Server it can broke other users Excel Integration (backup t370 object).

    Try to reinstall Excel 2013, if there is no "Microsoft Excel Object Library" in Automation list.

    Maybe earlier you have Excel 2007\2010 and then install 2013 over it, and all was fine.
    And now you uninstall all of it, and install ONLY 2013. That may cause all your trouble.
    I had Excel 2013 from the beginning, no 2007 or 2010 and it used to work just fine.
    It is not a network installation, I am using a local installation, just on my machine for coding and testing purposes....,so no other user will be affected...
    SO, shall I reinstall Excel 2013?
  • KeeperRUKeeperRU Member Posts: 58
    poppins wrote:
    KeeperRU wrote:
    I think you need to find "Microsoft Excel 15.0 Object Library" in list.
    SO, shall I reinstall Excel 2013?

    Try it, you have nothing to lose :-k
Sign In or Register to comment.