Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 683
  • Last Modified:

missing reference microsoft.interop.excel in visual web developer

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
solarissf
Asked:
solarissf
  • 3
  • 2
2 Solutions
 
shanejhCommented:
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
 
solarissfAuthor Commented:
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
 
shanejhCommented:
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
 
solarissfAuthor Commented:
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
 
solarissfAuthor Commented:
I added to solution
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now