Hi,
I finally got the CreateObject("Excel.Application",\\MyServer) working but I
have another serious problem.
I open the Excel.Application in remoter server and open the workbook and
read and process the data. But the process is done, the Excel instance
doesn't close and it creates a new instance every time. Here is my code.
Please help..
Dim objExcelApp As Excel.Application
Dim objWorkBook As Excel.Workbook
Dim objWorkSheet As Excel.Worksheet
Dim objRange As Excel.Range
objExcelApp = CType(CreateObject("Excel.Application",
ConfigurationSettings.AppSettings("AppServer")), Excel.Application)
objExcelApp.DisplayAlerts = False
objWorkBook = CType(objExcelApp.Workbooks.Add(WorkBookPath), Excel.Workbook)
objWorkSheet =
CType(objWorkBook.Worksheets(ConfigurationSettings.AppSettings("WorkSheetPat
h")), Excel.Worksheet)
''Do the processing......................
ReleaseComObject(objWorkSheet)
ReleaseComObject(objWorkBook)
ReleaseComObject(objExcelApp)
objRange = Nothing
objWorkBook = Nothing
objWorkSheet = Nothing
objExcelApp = nothing
If Not IsNothing(objExcelApp) Then
objExcelApp.DisplayAlerts = False
objExcelApp.Quit()
objExcelApp = Nothing
End If
GC.Collect()
[quoted text, click to view] "Dmitriy Lapshin [C# / .NET MVP]" <x-code@no-spam-please.hotpop.com> wrote
in message news:u2V3B2hpEHA.3324@TK2MSFTNGP15.phx.gbl...
> Hi KC,
>
> You can grant permissions to the user your ASP .NET app runs under to
access
> the Excel COM server by running dcomcnfg on the "MyServer" machine. For
> this, the aforementioned user should be a domain user. You could possibly
> also impersonate a domain user with enough permissions before
instantiating
> and using the Excel object.
>
> --
> Sincerely,
> Dmitriy Lapshin [C# / .NET MVP]
> Bring the power of unit testing to the VS .NET IDE today!
>
http://www.x-unity.net/teststudio.aspx >
> "KC" <chhatra@hotmail.com> wrote in message
> news:OAagClZpEHA.3324@TK2MSFTNGP15.phx.gbl...
> > Hi,
> > I have code similar to this..
> > Dim xlApp As Object
> > xlApp = CreateObject("Excel.Application", "\\MyServer")
> >
> > The call is from a asp.net (Intranet) application. \\Myserver is a
network
> > computer in the same domain as web server. The only way I can get this
> > call
> > worked is when I add the user who logs on to the web site as
> > Administrators.
> > I need to get this working without having to make the user
administrator.
> > Any suggestion?
> > Thanks,
> > CK
> >
> >
>
