How to remove an error when working with Excel using C#?

Question

excel

Added a link to EXCEL.EXE, which made it possible to connect Microsoft.Office.Interop.Excel
When compiling, it knocks out several errors:
- Failed to determine the dependencies of COM "VBIDE" links. Error loading library.
- Failed to determine dependencies of COM references "Microsoft.Office.Interop.Excel". Error loading library. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY))
And further attempts to use some functions either cause exceptions and the program crashes. Please tell me how to solve the problem. I really want to work with Excel files through C#.
Thank you all in advance for your help.

Answer 1

Add a link to the Microsoft Visual Basic for Applications Extensibility 5.3 library to the project links
And you also need not a link to Excel.exe, but in the same place in the project references add a link to Microsoft.Office.Interop.Excel