General

Re: Run Macro Excle from asp .net

Zhao Ji Ma - MSFT — Wed, 04 Jun 2008 09:07:53 GMT

Hi brunello71,

brunello71:
I used the "Internet Guest Account" under DCOM Config

You can try the suggestions like mentioned in the same KB:

•	Configure all instances of the Office application that is started by Automation to run as the Interactive user.
•	Configure all instances of the Office application that is started by Automation to run as a specific user.
•	Configure your code to run as a specific user by using an MTS/COM+ package and allowing the Office application to inherit the identity of the user that launches the application.

Detailed steps are also available in this KB.

Re: Run Macro Excle from asp .net

brunello71 — Fri, 30 May 2008 15:02:01 GMT

Thank you tomkmvp,

but I must use Excel and I can't use another way.....

Re: Run Macro Excle from asp .net

brunello71 — Fri, 30 May 2008 15:00:21 GMT

I used the "Internet Guest Account" under DCOM Config

Re: Run Macro Excle from asp .net

tomkmvp — Fri, 30 May 2008 14:40:46 GMT

brunello71:
What else can I do?

Find a better way:
http://support.microsoft.com/kb/257757

Re: Run Macro Excle from asp .net

jeff@zina.com — Fri, 30 May 2008 14:18:59 GMT

brunello71:
I set all the permissions on the server...

What does this mean? Do you even know what account is accessing the files?

Jeff

Run Macro Excle from asp .net

brunello71 — Fri, 30 May 2008 13:57:25 GMT

Hi,

I have to run a simple Macro on an Excel File (Microsoft Excel 2003) from an asp .net application
on my local machine (Windows XP) the macro works correctly, but if I run the application on the web server (Windows Server 2003) at the "oXL.Run("Macro1")" instruction the application get stopped.
I set all the permissions on the server...
What else can I do?

follow my application code:

Dim oXL As Object = Nothing
Dim oXLWorkbooks As Object
Dim oXLWorkbook As Object
Dim oXLSheets As Object = Nothing
Dim oXLSheet As Object = Nothing
Dim oXLRange As Object = Nothing

        Try
            oXL = CreateObject("Excel.Application")
            oXL.DisplayAlerts = False
            oXL.Visible = True

            oXLWorkbooks = oXL.Workbooks
            oXLWorkbook = oXLWorkbooks.Open(PathFileMacro, 0, True)

            ************************STOP HERE
           'run the macro
           oXL.Run("Macro1")
           *********************************************
        Catch ex As Exception
            Exit Function
        Finally

            System.Runtime.InteropServices.Marshal.ReleaseComObject(oXLWorkbook)
            oXLWorkbook = Nothing
            System.Runtime.InteropServices.Marshal.ReleaseComObject(oXLWorkbooks)
            oXLWorkbooks = Nothing
            oXL.Quit()
            System.Runtime.InteropServices.Marshal.ReleaseComObject(oXL)
            oXL = Nothing
            CloseExcel()
            GC.Collect()
            GC.WaitForPendingFinalizers()
        End Try

thanks....

Bruno