Solved

missing reference microsoft.interop.excel in visual web developer

Posted on 2012-04-02
5
657 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
[X]
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
  • 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Shoutout to Emily Plummer (http://www.experts-exchange.com/members/eplummer26.html) for giving me this article! She did most of it, I just finished it up and posted it for her :)    Introduction In a previous article (http://www.experts-exchang…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL several years ago, it seemed like now was a good time to update it for object-oriented PHP.  This article does that, replacing as much as possible the pr…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.

726 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