authandication problem for remote excel gnatt chart

[absprogrammer]

hi, i'm openin MS excel and genrating gnatt chart using code as below. gnatt charts are open on server machine properly. but it does not open excel(only page refresh) on client machine. But when it open at client machine it always ask username,password windows. I want to open it without username,password window Can anybody knows what is solve problem?:confused: Sub excelgnattchart(ByVal stringWrite) Try Dim ExcellProcess() As System.Diagnostics.Process = System.Diagnostics.Process.GetProcessesByName("EXCEL") Dim a As Int32 = ExcellProcess.Length() Dim b As Int32 = 0 If (a > 0) Then While a > b ExcellProcess(b).Kill() b = b + 1 End While End If Catch ex As Exception End Try Dim oExcel As New Excel.ApplicationClass Dim oBook As Excel.WorkbookClass Dim oBooks As Excel.Workbooks Dim fname As String = "c:\chart.xls" Try Dim file As New FileInfo(fname) Dim sWriter As TextWriter = file.CreateText() sWriter.WriteLine(stringWrite.ToString) sWriter.Flush() sWriter.Close() oExcel.Visible = True oBooks = oExcel.Workbooks oBook = oBooks.Open(fname, , True) oExcel.Cells.Select() oExcel.Charts.Add() oExcel.ActiveChart.ChartType = Excel.XlChartType.xlColumnClustered oExcel.ActiveChart.Location(Excel.XlChartLocation.xlLocationAsNewSheet) oExcel.ActiveChart.HasTitle = False oExcel.Charts.Move() oBook.Close(False) System.Runtime.InteropServices.Marshal.ReleaseComObject(oBook) oBook = Nothing System.Runtime.InteropServices.Marshal.ReleaseComObject(oExcel) oExcel = Nothing System.GC.Collect() GC.WaitForPendingFinalizers() file.Delete() Catch ex As Exception Console.Write("Exception :" & ex.Message) End Try