Excel System.UnauthorizedAccessException

[Jane]

I got the web application to open up the excel. It works fine on my
development box. But when i moved it to the production server, I cannot get
the Excel spreadsheet to open. I get System.UnauthorizedAccessException:
Access is denied.
I've granted full access for the excel file stored in the server, but still
can't access it. Please help!

[Victor Hadianto]

Have you tried granting the ASP user to have read access of the file? By
default this is ASPNET. Make sure you don't have 'deny' permission on that
file as well since it has higher precedence than the 'allow' permission.

--
Victor Hadianto
http://synop.com/Products/SauceReader/

"Jane" <Ja**@discussions.microsoft.com> wrote in message
news:16**********************************@microsof t.com...

I got the web application to open up the excel. It works fine on my
development box. But when i moved it to the production server, I cannot
get
the Excel spreadsheet to open. I get System.UnauthorizedAccessException:
Access is denied.
I've granted full access for the excel file stored in the server, but
still
can't access it. Please help!

[Cor Ligthert]

Jane,

Is it opening the file on the clientside or the serverside?

Cor

"Jane" <Ja**@discussions.microsoft.com>
..

I got the web application to open up the excel. It works fine on my
development box. But when i moved it to the production server, I cannot
get
the Excel spreadsheet to open. I get System.UnauthorizedAccessException:
Access is denied.
I've granted full access for the excel file stored in the server, but
still
can't access it. Please help!

[Jane]

I have granted permission....
I'd like the excel to open on the client side, but seems like is not doing
it....

here's my code:

Excel.ApplicationClass excelObj = new Excel.ApplicationClass();
excelObj.Visible=true;
Excel.Workbook newbook =
excelObj.Workbooks.Add(Excel.XlWBATemplate.xlWBATW orksheet);
Excel.Workbook workBook =
excelObj.Workbooks.Open(strFileName,0,true,5,"","" ,true,Excel.XlPlatform.xlWindows,"",false,false,0, true,true,false);
Excel.Sheets sheets = workBook.Worksheets;
Excel.Worksheet dataSheet = (Excel.Worksheet)sheets.get_Item("Trade Ticket
Lookup");
Excel.Range range = dataSheet.get_Range("B2",Type.Missing);
dataSheet.Select(Type.Missing);
range.Cells.Value2=tradeID;

Excel.Worksheet tradesRealSheet = (Excel.Worksheet)sheets.get_Item("Trades
(Real)");
tradesRealSheet.Select(Type.Missing);

excelObj.Application.Quit();

I don't know what I'm doing wrong here, please help!
Thanks!

"Cor Ligthert" wrote:

Jane,

Is it opening the file on the clientside or the serverside?

Cor

"Jane" <Ja**@discussions.microsoft.com>
..

I got the web application to open up the excel. It works fine on my
development box. But when i moved it to the production server, I cannot
get
the Excel spreadsheet to open. I get System.UnauthorizedAccessException:
Access is denied.
I've granted full access for the excel file stored in the server, but
still
can't access it. Please help!

[Cor Ligthert]

Jane,

I saw that did not read it well, sorry, however maybe can this link help
you?

http://support.microsoft.com/default...;EN-US;Q257757

Cor