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.xlWBATWorksheet);
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!
[quoted text, click to view] "Cor Ligthert" wrote:
> Jane,
>
> Is it opening the file on the clientside or the serverside?
>
> Cor
>
> "Jane" <Jane@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!
>
>