Error while exporting report data to excel

poppins

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

geordie

What Office version are you using? With NAV 2009 32-bit Office installation is recommended.
Does a "simple" data export work fine?

KeeperRU

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.

poppins

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

KeeperRU

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.

poppins

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?

KeeperRU

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