error code 0x80020009

Avinash Rajkumar 0 Reputation points
2024-05-17T07:56:40.15+00:00

I have control system server (windows server 2016 & Microsoft office 2013) the control system software is ABB 800xA that auto generate daily excel report, this feature was stopped suddenly with error code "0x80020009" and error message "open method of workbooks class failed" when excel is closed and error message "activeX component cannot create object" when excel is opened.

Any procedure/help to solve this problem and get the excel reports to be generated again.

Windows Server 2016
Windows Server 2016
A Microsoft server operating system that supports enterprise-level management updated to data storage.
2,420 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Jing Zhou 4,055 Reputation points Microsoft Vendor
    2024-05-20T07:22:54.1+00:00

    Hello,

     

    Thank you for posting in Q&A forum.

    To troubleshoot this issue from Windows OS level, please kindly try below steps:

    1.Check if excel works fine on the server.

    2.Check if the service account of ABB 800xA has proper permission to excel.

    3.Try to repair or reinstall Office and see if it helps.

    Meanwhile, please kindly engage AAB 800xA software support team for troubleshooting from their side.

     

    Best regards,

    Jill Zhou

     


    If the Answer is helpful, please click "Accept Answer" and upvote it.