Link to home
Start Free TrialLog in
Avatar of mobileistic
mobileistic

asked on

Excel Interop on Windows 2012 Server

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!!!!


User generated image
Avatar of Daniel Van Der Werken
Daniel Van Der Werken
Flag of United States of America image

Do you have the appropriate version of Office installed on the system? It needs to be installed for Interop to work.
Avatar of mobileistic
mobileistic

ASKER

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.
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)?
ASKER CERTIFIED SOLUTION
Avatar of mobileistic
mobileistic

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
its what worked