Error Opening Excel Application in IIS7 RRS feed

  • Question

  • User-144431078 posted

    First, sorry about my english. I've a problem (it seems to be something very easy) with Opening Excel Application by ASP in IIS7. This code works fine in IIS6.

    Set objFSO = CreateObject("Scripting.FileSystemObject") 
    If objFSO.FileExists(Server.MapPath("/Today/File.xls")) then
      Set xl1 = CreateObject("Excel.Application")
      Set wb1 = xl1.Workbooks.Open(Server.MapPath("/Today/File.xls"))
      response.write "&load=ok"
    end if

    I know that the error is in the line [Set wb1 = xl1.Workbooks.Open(Server.MapPath("/Today/File.xls"))]The error that appears is the next:

    HTTP Error 500: Server internal Error. Description: There is a problem with the resource that it looks for and it is not possible to be shown.

    Saturday, April 21, 2007 2:06 PM

All replies