Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CreateObject("Excel.Application")
Each month this object runs in an asp application to create a workbook from
5 separate tables in a SQL 7.0 db. The app is great and performs successfully with the exception if the file is large - maybe 1000 lines per spreadsheet - 800KB. The last lines of code are as follows: xls.ActiveWorkbook.SaveAs server.MapPath(".") & "\" & fName xls.Quit Set xls = Nothing ' Release the object variable. set rsTbl1 = Nothing Response.Redirect ("https://www.foo.org/" & strChap & "/admin/" & strRedirect & ".asp?File=" & strfile & "") Once it completes the SaveAs command, the app hangs. It never quits or goes to the response.redirect. Does anyone no how to fix this issue? Or if I should be in another newsgroup? Olivia |