Solved

Excel Interop on Windows 2012 Server

Posted on 2014-10-14
5
566 Views
Last Modified: 2014-10-20
When trying to reference Excel I get the Error below on Windows 2012 server.  I am logged in as an admin and have full rights. When I browse to the AppData\Local\Temp\2 direcory i don't see a "Dir1" sub  Direcory.

HELP!!!!


Error Message
0
Comment
Question by:mobileistic
  • 3
  • 2
5 Comments
 
LVL 20

Expert Comment

by:Daniel Van Der Werken
ID: 40382003
Do you have the appropriate version of Office installed on the system? It needs to be installed for Interop to work.
0
 

Author Comment

by:mobileistic
ID: 40382208
Yes I have Office 2007 Enterprise installed on the machine.  I have now found I can add the reference to a Console or Form vb application but not a Website.  I think its some kind of rights issue when doing a website application.
0
 
LVL 20

Expert Comment

by:Daniel Van Der Werken
ID: 40382860
Okay. Web site. Note that a web site works under an application pool. The application pool runs under a user context. Usually it's Network Service.

What happens if you make the Network Service local admin on the server (just for testing purposes -- don't leave it at that high level of access)?
0
 

Accepted Solution

by:
mobileistic earned 0 total points
ID: 40382880
Problem fixed!  I re-installed office and it fixed the issues with adding the reference.
0
 

Author Closing Comment

by:mobileistic
ID: 40391529
its what worked
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Programmer's Notepad is, one of the best free text editing tools available, simply because the developers appear to have second-guessed every weird problem or issue a programmer is likely to run into. One of these problems is selecting and deleti…
For a while now I'v been searching for a circular progress control, much like the one you get when first starting your Silverlight application. I found a couple that were written in WPF and there were a few written in Silverlight, but all appeared o…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.

910 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

25 Experts available now in Live!

Get 1:1 Help Now