locked
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"))
      wb1.Close()
      xl1.Application.Quit()
      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