Unknown Excel automation in AL code inside VSCode

cesabo
cesabo Member Posts: 20
in NAV Three Tier
Hello,

I'm trying to migrate report from version 2018 to BC, but the thing is that Visual Studio Code doesn't support those Excel automations.

I'm struggling with that problem from a while, does anyone have idea how we are supposed to convert reports with export to excel option ?
I guess there must be some kind of workaround or something which I'm missing ?

Here is a screenshot of the problem.

rms3v3babhsc.png



Many thanks !

Answers

  • TallyHo
    TallyHo Member Posts: 417
    edited 2020-01-30
    This probably is a custom report thas has been migrated time after time using automation while std. NAV started using DotNet, but still supported the more and more obsoleted Automations. Now there is no way around it anymore, you'll have to refactor the code in this report to use DotNet. Take a look at Table 370 and other excel related objects, what you need to know is all there.
  • cesabo
    cesabo Member Posts: 20
    Many thanks for the hint, I got the answer to my question.
    Cheers

Categories