A problem I have is when I leave the website running overnight (it refreshes itself every minute), an error eventually pops up that says
"Not enough memory to run Microsoft Office Excel. Please close other applications and try again."
Internet Explorer also gives the error "Automation Server can't create object" on the line
Expand|Select|Wrap|Line Numbers
- var excel = new ActiveXObject("Excel.Application");
Expand|Select|Wrap|Line Numbers
- var excel = new ActiveXObject("Excel.Application");
- excel.visible=false;
- var excelfile = excel.Workbooks.Open("displayinfo.xls");
- var excelsheet = excel.Worksheets("Sheet1");
Expand|Select|Wrap|Line Numbers
- excelfile.Close(false);
- excel.Quit();
- excel = null;
- setTimeout("CollectGarbage()",1);