Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

missing reference microsoft.interop.excel in visual web developer

Posted on 2012-04-02
5
Medium Priority
?
682 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 2000 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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Browsers only know CSS so your awesome SASS code needs to be translated into normal CSS. Here I'll try to explain what you should aim for in order to take full advantage of SASS.
Geo-targeting is the practice of distributing content based on a person’s location, as best as you can determine it. Let’s look at some ways you could successfully use this tactic. The following tips and case studies could lead to meaningful results.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
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…
Suggested Courses

572 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