Results 1 to 2 of 2

Thread: Error

  1. #1
    Join Date
    Dec 1969

    Default Error

    i just run the following codes and errors occurs<BR><BR>Set xlApplication = Server.CreateObject("Excel.Application")<BR>xlAppl ication.Workbooks.Close<BR>xlApplication.Workbooks .Open "D:Template.xls"<BR>Set xlWorksheet = xlApplication.Worksheets(1)<BR>xlWorksheet.SaveAs Server.MapPath(".") & "month" & ".xls"<BR>xlApplication.Quit <BR>Set xlWorksheet = Nothing<BR>Set xlApplication = Nothing<BR><BR>Error encountered:<BR><BR>Server object error &#039ASP 0196 : 80040154&#039 <BR><BR>Cannot launch out of process component <BR><BR>Only InProc server components should be used. If you want to use LocalServer components, you must set the AspAllowOutOfProcComponents metabase setting. Please consult the help file for important considerations. <BR><BR>what are the settings that i need to make..<BR>thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Error

    allowOutOfProcCmpts = 1 - to change this in IIS 3.0 you do it in the registry - in IIS 4.0 and 5.0 you change it in the Metabase (which you already knew by the error) - the key is making the change -more information can be found in the online documentatin that somes with ISS <BR><BR>why don&#039t you just export a table to excel using &#060;%Response.ContentType="application/"%&#062; at the top of your ASP? it is much easier and doesn&#039t require server changes<BR><BR>bart

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts