System. runtime. interopservices. comexception (0x8000401a): retrieving the com class factory for compo

This problem has plagued me for a long time, and it is useless to find a lot of information on the Internet,

Finally, find the solution:

Run dcomcnfg to open the component service,

Expand "component service"> "computer"> "my computer"> "DCOM configuration" in turn"

Find "Microsoft Excel application" or "Microsoft Word application ",

Right-click the Properties dialog box and click the "ID" tab,

Click "The following users" to enter the Administrator's user password correctly...

Click the "Security" tab,

Select "Start and activate Permissions", "Access Permissions", and "Configure permissions" as custom,

Click Edit to add everyone and add all the permissions to it...

OK to solve this problem!