Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

missing reference microsoft.interop.excel in visual web developer

Posted on 2012-04-02
5
650 Views
Last Modified: 2012-06-27
Can someone pleasee tell me how to add microsoft.office.interop.excel to visual web developer... cant figure out how to install or add it

i've tried reinstalling vs studio 2010 express and still nothing

thank you!
0
Comment
Question by:solarissf
  • 3
  • 2
5 Comments
 
LVL 2

Accepted Solution

by:
shanejh earned 500 total points
ID: 37799423
Are you trying to use this in an application you are writing?

To use it in an application you should add it as a reference.
 - If you don't already have them you will need to download the PIA's from MS
http://www.microsoft.com/download/en/details.aspx?id=3508 
- Once installed you should be able to create a new application
- In your solution tree right click on references and click add reference.
- Under the .net tab you should find the option for 'Microsoft Office Interop Excel'

From then it's all code.
0
 

Assisted Solution

by:solarissf
solarissf earned 0 total points
ID: 37800343
I tried downloading the PIA about 5 times to no avail.  After 4.5 hours all I found out all I needed to do was re-install Excel... no clue why.  But after I did the Microsoft.Office appeared in the .net tab.

thanks for the assistance
0
 
LVL 2

Expert Comment

by:shanejh
ID: 37800437
What a pain.

Just for future reference. If you don't see a reference but know you have the related software installed you can always search for the .dll and add the reference that way. Not the ideal solution but one which will work 99% of the time.

Good luck with your work.
0
 

Author Comment

by:solarissf
ID: 37800445
appreciate it... yes I tried that too... the .dll files were not on my pc.  Even after I installed the PIA multiple times... who knows... but thanks for the help
0
 

Author Closing Comment

by:solarissf
ID: 37820805
I added to solution
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…
HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question