I am trying to use this namespace and downloaded the O2003pia.exe from http://support.microsoft.com/kb/897646.

I ran the msi and see the Interop files in the GAC but when I try to 'Add a Reference' in VS2005, I do not see any of the Interop namespaces.

I already had Office 2003 installed before I ran the above msi.

What else am I doing wrong. Why aren't these included with VS2005 in the first place..............

Please help,

JJM

Thanks!

Thanks!

Hi Feng Chen,

I m also facing the same problem, i have already added the microsoft.excel 11.0 reference then also it is not identifying the Microsoft.Office.Interop.Excel namespace.It is giving Microsoft.Office.core but not Microsoft.Office.Interop.Excel namespace.What should I do?

Plz help.

By adding microsoft.excelreference in VS2005, You will find Interop.Excel & Microsoft.Office.coreinstead of Microsoft.Office.Interop.Excel.

yaa that was the problem with me also.

until or unless we add Microsoft.Office.Interop.excel dll explicitely from reference it doesn't show that option.

And this reference is available only with licensed version.It means when we hav licensed version for both .net and Microsoft office.

Hi

Try

the following

using Excel = Microsoft.Office.Interop.Excel;

and use Excel

it's working for me

good luck

If you have to install the new Interop package from Microsoft, make sure you exit Visual Studio and re-open your project. This should help. It took me a couple of hours to figure this one out.

• Edited byRobiSingh Thursday, November 13, 2008 2:08 PM
•  

Thursday, August 13, 2009 4:59 PMVickyJicky

 

0

Sign In to Vote

My Easy Solution:

1. Download and install pre op assemblies files from the microsoft site: 'OFFICE XP PIAs'

2. I unzipped and save all files to a directory Ain my local machine.

3. There will be a file called register.bat in the directory A. simply double click that file.. register entries will automatically happen

4. After unzipping the contents, i copied all the files from that directory 'A' to C:\Program Files\Microsoft.Net\Primary Interop Assemblies\ (you can overwrite the existing files .. no prob)

5. In your visual studio IDE, click Add Reference.. go to tab '.NET'. Locate and click select 'Micrsoft Office Interop Excel'.

6. Now you can use in your code ..Imports Excel = Microsoft.Office.Interop.Excel

Please tell if me if is worked. It worked for me!

I have done what you have told above but I cannot add a reference into Visual Studio IDE. I have copied all the files in the required location but still cannot use Microsoft.Office.Interop.Excel.

Please guide me.