web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Export to Excel with automation

(0) ShareShare
ReportReport
Posted on by 2,205

Cannot create an instance of an Automation Server with CLSID = {000208D5-0000-0000-C000-000000000046}

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

    At which point, you are getting this error?

    It seems some excel library / version issue?

    Are you getting this issue in different computers as well?

  • sanjeet Profile Picture
    2,205 on at

    When I m trying to run the report...!

    Yes i have tried to run this report on different system but error the same

  • Suggested answer
    Community Member Profile Picture
    on at

    Are you trying to build new report or migrating from classic version?

    Are you using Excel Buffer Table?

    When you debug the report, where exactly it is stopping?

  • sanjeet Profile Picture
    2,205 on at

    No this is new Report...!

    No I am not using Excel Buffer Table.

    it is stoping on this Piece of Code

    CREATE(xlApp, TRUE, TRUE);

     xlApp.Visible(FALSE);

     xlWorkBook := xlApp.Workbooks.Add;

     EXIT(NoOfRows);

  • Suggested answer
    Community Member Profile Picture
    on at

    Can you please compile Excel Buffer Table and see if it is giving any error message?

  • Suggested answer
    keoma Profile Picture
    32,729 on at

    this is an issue with Microsoft.Office.Interop.Excel. maybe the wrong excel version is referenced. which report do you use, budget-export to excel ? if yes, then check the used excel automation/assembly versions in table excel buffer.

  • Verified answer
    keoma Profile Picture
    32,729 on at

    what is the subtype of xlApp? maybe the automation is missing or not registered correctly (regsvr32).

    for details follow https://moxie4nav.wordpress.com/2016/02/25/cannot-create-an-instance-of-an-automation-server-with-clsid-guid/

  • sanjeet Profile Picture
    2,205 on at

    Thanks Jonathan....

    this is because of subtype...now rectified.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans