469,347 Members | 19,184 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,347 developers. It's quick & easy.

Excel - Access Denied

Hello, I am using a generic AD Domain Account to create an excel spreadsheet,
but I am getting an "Access Denied" error when I attempt to instatiate the
excel object. The generic account does is set up in such a way that I can
not log on to the server with the account but it is a valid account as I have
used it in other applications. The code works perfectly fine when I use my
own account ID and password. So there is something about this account in
relationship to excel which is not set up correctly. I seem to remember that
I got an error on my own account on the server if I had never started excel
under my own account, but I do not recall what the error was. Since I can
not log on with this generic account, what would I need to do to prep the
account for the generic account (assuming that this is what the error is)?

Thanks in advance for your assistance
Jan 16 '06 #1
1 1942
When Excel is run for the first time it installs some settings for you. I
assume this would be stored in the Application Data folder of the user
profile on the server...

C:\Documents & Settings\user\Application Data

But there may be some registry settings that get written for the CurrentUser
as well.

A start if you don't want to log on with the user may be to copy the
contents of the Application Data folder for a user that has logged on in the
past across to the new user that can't log on.

Hope that this helps to point you in the right direction, let me know how
you get on.

--
Kurt Farrar
..NET Developer & Computer Enthusiast

"Jim Heavey" wrote:
Hello, I am using a generic AD Domain Account to create an excel spreadsheet,
but I am getting an "Access Denied" error when I attempt to instatiate the
excel object. The generic account does is set up in such a way that I can
not log on to the server with the account but it is a valid account as I have
used it in other applications. The code works perfectly fine when I use my
own account ID and password. So there is something about this account in
relationship to excel which is not set up correctly. I seem to remember that
I got an error on my own account on the server if I had never started excel
under my own account, but I do not recall what the error was. Since I can
not log on with this generic account, what would I need to do to prep the
account for the generic account (assuming that this is what the error is)?

Thanks in advance for your assistance

Jan 16 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by sk | last post: by
2 posts views Thread by Ryan Ternier | last post: by
2 posts views Thread by Alex D. | last post: by
8 posts views Thread by jack | last post: by
12 posts views Thread by D. Shane Fowlkes | last post: by
reply views Thread by =?Utf-8?B?TW9udGU=?= | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.