Solved

missing reference microsoft.interop.excel in visual web developer

Posted on 2012-04-02
5
636 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This article covers the basics of the Sass, which is a CSS extension language. You will learn about variables, mixins, and nesting.
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.
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

747 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now