VB.NET Error (Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154)

There are two workarounds

1.it a platform issue just compile your code with 'X86' rather than 'Any CPU'
to do that click on ProjectMenu --> windows form properties --> Build tab --> platform target change it to X86

--------------------------------------------------------

2. click on Start --> Run
type dcomcnfg component services window will open.
component services --> computers --> MyComputer --> DCOM Config --> select microsoft EXCEL application

right click on it --> properties --> security --> Lunch and activation permission TAB

select customize TAB --> click on edit add Network Services user and Users group give permission.

do same for access permission and configuration permission.

exel not found in location/dcom config