[Solved] Could not resolve this reference. Could not locate the assembly "Microsoft.Office.Interop.Outlook, Version=14.0.0.0

Introduction

You may experience this error if you try to compile a visual studio solution/project where it is referring to this Microsoft.Office.Interop.Outlook from GAC. This could also happen in a build server where you don’t have outlook installed. You may feel like you hit the dead end where you are forced to install the licensed Microsoft office tools. But we have another alternative which is completely free and ethical.

How did I fix this?

         This is the nuget package. We have a nuget library package which is an alternative to Microsoft.Office.Interop.Outlook. This has the same syntax as the interop Microsoft.Office.Interop.Outlook dll. This is called as NetOffice. All the syntax and classes will be same but reference will be different.

Read More

[Solved] Could not resolve this reference. Could not locate the assembly "Microsoft.Office.Interop.Excel, Version=14.0.0.0

Introduction

You may experience this error if you try to compile a visual studio solution/project where it is referring to Microsoft.Office.Interop.Excel from GAC. This could also happen in a build server where you don’t have or want any tools which are licensed because you don’t want to pay for it as you spawn servers at runtime. You may feel like you hit the dead end where you are forced to install Microsoft office tools. But we have another alternative which is completely legal and ethical.

How did I fix this?

This is the nuget package. We have this Microsoft.Office.Interop.Excel dll available as a nuget package. This is called Excel-DNA.Interop. This Microsoft.Office.Interop.Excel dll which comes in this nuget package has no dependency and is pretty straightforward to use. Use it just like any other nugget package!

Read More