Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Export to Excel with automation

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

  • sanjeet Profile Picture
    sanjeet 2,205 on at
    RE: Export to Excel with automation

    Thanks Jonathan....

    this is because of subtype...now rectified.

  • Verified answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Export to Excel with automation

    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/

  • Suggested answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Export to Excel with automation

    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.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Export to Excel with automation

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

  • sanjeet Profile Picture
    sanjeet 2,205 on at
    RE: Export to Excel with automation

    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
    Community Member Microsoft Employee on at
    RE: Export to Excel with automation

    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
    sanjeet 2,205 on at
    RE: Export to Excel with automation

    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
    Community Member Microsoft Employee on at
    RE: Export to Excel with automation

    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?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans