Microsoft.Office.Core Reference Missing

Question

Using the example provided in codeproject I am struggling to work out where I can find the reference to the library Microsoft.Office.Core.

I am getting the error "The referenced component 'Microsoft.Office.Core' could not be found."

I only have office 2007 enterprise edition and outlook 2003 installed on this system. Could this be the cause of this? Otherwise which specific dll am I supposed to be referencing?

Tried both suggestions and still seem to be stuck. The question is what is the "COM Library appropriate for your system" in my case? — Maxim Gershkovich, May 09 '11 at 05:55

score 162 · Accepted Answer · answered Sep 06 '12 at 07:07

162

You can add reference of Microsoft.Office.Core from COM components tab in the add reference window by adding reference of Microsoft Office 12.0 Object Library. The screen shot will shows what component you need.

enter image description here

answered Sep 06 '12 at 07:07

Adil

139,325
23
196
197

.NET->Office (if PIA installed). See Spike's answer below. – samis Dec 30 '14 at 21:34
4

I used "Microsoft Office **14.0** Object Library" (12.0 didn't exist) and it worked as well. Also, I had to delete the reference to "Microsoft.Office.Core" first. – marsze Mar 09 '17 at 09:37
Jazakallah Adil bhai. Worked for me. – shaikhspear Apr 01 '17 at 09:47
2

I am using Visual Studio 2017 but I cannot see the the "Microsoft Office XX.X Object Library" in the COM tab. Do I need to install "Microsoft Office"? – Casper Jul 27 '17 at 01:26
@Kin Did you find out what to do? I'm also using VS 2017 and I don't see a reference to the office's libraries. Did you have to install Microsoft Office? – Luis Palacios Sep 27 '17 at 16:21
Thank you very much – destinydz Dec 28 '17 at 10:12
@Kin Once you add the reference from the COM tab, reference it in the class file with `using Outlook = Microsoft.Office.Interop.Outlook;` – killa-byte Aug 29 '18 at 20:33
I used "Microsoft Office 16.0 Object Library" (12.0 didn't exist) and it worked as well. Also, I deleted the reference to "Microsoft.Office.Core" first. This is when I have Office App (Office 365) installed version 18.2008.12711.0 and also Visual Studio 2019 installed along with Visual Studio 2005 – Ozair Kafray Jan 26 '21 at 14:37

score 24 · Answer 2 · answered Dec 19 '17 at 07:21

None of the above answer helped me, i was using Visual Studio 2017. What I did is, installed Office/SharePoint Development using Visual Studio Installer.

After that, I was able to see 'office', this assembly contains Microsoft.Office.Core.

Hope this helps you.

score 18 · Answer 3 · answered May 09 '11 at 05:23

18

You need to download and install the PIA (primary interop assemblies) for the version of Office you are using. Once installed you can then add a reference to your project and they will be available from the add reference dialog. Here are the links to download them...

Office 2010 PIA

Office 2007 PIA

Office 2003 PIA

answered May 09 '11 at 05:23

Phil Wright

21,516
12
77
129

7

Tried all three. No luck thus far! – Maxim Gershkovich May 09 '11 at 08:58
3

Installed PIA but couldn't find them in "Add reference", but then it worked for me by adding the DLL from path directly e.g. C:\Windows\assembly\GAC_MSIL\Microsoft.Office.Interop.Excel\xxxx\.... – oo_dev Dec 08 '15 at 07:41
2

I have been able to find the other PIAs but not Microsoft.Office.Core – JohnD Mar 16 '16 at 19:43
Still doesn't show up in the COM list to add as reference – Edward Jun 03 '17 at 03:34

score 5 · Answer 4 · edited Oct 31 '15 at 17:24

5

If someone not have reference in .NET . COM (tab) or not have office installed on machine where visual was installed can do :

Download and install: Microsoft Office Developer Tools

Add references from:

C:\Program Files (x86)\Microsoft Visual Studio 11.0\Visual Studio Tools for Office\PIA\Office15

edited Oct 31 '15 at 17:24

shA.t

15,232
5
47
95

answered Jul 24 '15 at 15:40

Artur Tarnowski

61
1
3

score 4 · Answer 5 · answered Aug 17 '14 at 20:14

4

After installing the Office PIA (primary interop assemblies), add a reference to your project -> its on the .NET tab - component name "Office"

answered Aug 17 '14 at 20:14

Spike

59
1

1

Upvoted because this actually did it to me. Initially setting the references to .COM did not solve the problem. – DrMarbuse Nov 08 '16 at 08:58
Be nice to know where this .NET tab is – Edward Jun 03 '17 at 03:26

score 3 · Answer 6 · answered Nov 28 '16 at 21:45

3

Now there is a nuget package for that.

https://www.nuget.org/packages/NetOffice.Core.Net40/

First I didn't find office in COM, so tried this nuget and it worked!

answered Nov 28 '16 at 21:45

Mr. Ott

191
1
2
12

1

Adding to answer: If you install an Office Interop lib through the NuGet package manager console (say PowerPoint or Excel), it looks to install this, too... the same does not seem to be true if you use the Visual Studio NuGet GUI – Thumper Jul 11 '17 at 21:45

score 3 · Answer 7 · answered Jun 10 '20 at 17:05

3

You can use this NuGet package which includes the interop assemblies in addition to the office assembly.

https://www.nuget.org/packages/Bundle.Microsoft.Office.Interop/

answered Jun 10 '20 at 17:05

Matt Scully

373
2
9

score 2 · Answer 8 · edited May 21 '15 at 22:24

2

In case you are using Visual Studio 2012, for this to work and in order to make reference to Microsoft Office Core, you have to make the reference through Visual Studio by clicking on the top menu's Project, Add Reference, Extensions button and checking office which is now (14.0).

edited May 21 '15 at 22:24

Celeo

5,017
8
35
39

answered May 21 '15 at 21:41

Humbert

41
2

score 2 · Answer 9 · answered May 09 '11 at 05:22

Have you actually gone to your references and added a .NET reference to the 'Microsoft.Office.Core' library? If you downloaded the example application, the answer would be yes. If that is the case, follow the advice in the article:

If your system does not have Microsoft Office Outlook 2003 you may have to change the References used by the "OutlookConnector" project. That is to say, if you received a build error described as "The type of namespace name 'Outlook' could not be found", you probably don't have Office 2003. Simply expand the project references, remove the afflicted items, and add the COM Library appropriate for your system. If someone has a dynamic way to handle this, I'd be curious to see you've done.

That should solve your problem. If not, let us know.

score 1 · Answer 10 · answered Feb 23 '18 at 07:26

If you are not able to find PIA for Office 2013 then follow these steps:

Click on Solution Explorer in Visual Studio

Right click on your project name (not solution name)

Select 'Manage Nuget packages'

Click on Browse and search for PIA 2013, choose the shown PIA and click on Install.....

And you are done.

score 0 · Answer 11 · answered Oct 25 '18 at 15:08

I faced the same problem when i tried to open my old c# project into visual studio 2017 version. This problem arises typically when you try to open a project that you made with previous version of VS and open it with latest version. what i did is,i opened my project and delete the reference from my project,then added Microsoft outlook 12.0 object library and Microsoft office 12.0 object libraryMicrosoft outlook 12.0 object library

score 0 · Answer 12 · answered Mar 01 '21 at 04:41

0

In my case when I added "Microsoft Excel Object Library" and "Microsoft Office Object Library" from Reference->COM then the reference error goes away.

answered Mar 01 '21 at 04:41

Nahidul Islam

1
1

score -1 · Answer 13 · answered Aug 11 '16 at 18:29

I have the same trouble. I went to Add references, COM tab, an select Microsoft Office 15.0 Objetct Library. Ok, and my problem ends.

part of my code is:

EXCEL.Range rango;
            rango = (EXCEL.Range)HojadetrabajoExcel.get_Range("AE13", "AK23");
            rango.Select();
      //      EXCEL.Pictures Lafoto = (EXCEL.Pictures).HojadetrabajoExcel.Pictures(System.Reflection.Missing.Value);
            EXCEL.Pictures Lafoto = HojadetrabajoExcel.Pictures(System.Reflection.Missing.Value);

            HojadetrabajoExcel.Shapes.AddPicture(@"D:\GENETICA HUMANA\Reportes\imagenes\" + Variables.nombreimagen,
                Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoCTrue,
                float.Parse(rango.Left.ToString()),float.Parse(rango.Top.ToString()), float.Parse(rango.Width.ToString()),
                float.Parse(rango.Height.ToString()));

Microsoft.Office.Core Reference Missing

13 Answers13

Linked