How can I open an excel sheet in different credential?

Question

0.00/5 (No votes)

See more:

, +

Opening an excel sheet using StartInfo is not working.

What I have tried:

I tried impersonating using the impersonation class, it is not working. Then I passed my user credential using Process.StartInfo.UserName and Process.StartInfo.Password, it is not working. I am opening a CMD prompt with a different user credential, then I am using the command "/C start excel '\\mynetwork\filename.xls'"

Posted 17-Jun-16 3:36am

Strikerzz Arut

Updated 17-Jun-16 4:19am

v2

Add a Solution

2 solutions

Solution 1

The user you impersonate has to have permissions to the network share you're trying to open the file from.

Also, a UNC path is \\servername\sharename\folderpath\filename

Posted 17-Jun-16 4:05am

Dave Kreskowiak

Comments

Strikerzz Arut 17-Jun-16 10:18am

The user has the full control over the network path which I am trying to access.

The UNC path is similar to the one you have given.

Dave Kreskowiak 17-Jun-16 10:19am

OK, without seeing the code you wrote to do this, it's pretty much impossible to tell you what you're doing wrong.

Strikerzz Arut 17-Jun-16 10:20am

Sorry about that and I have posted my answer below. Using impersonation class won't work. We should use Process to open the Excel in different user credentials.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Strikerzz Arut · Accepted Answer · 2016-06-17T04:19:00

Solution 2

Process.StartInfo.LoadUserProfile is set to true and it does the trick.

Posted 17-Jun-16 4:19am

Strikerzz Arut