Posted by Harry on August 30, 2001 10:53 AM
I'm creating an Excel application as follows within a web page: -
ExcelApp = new ActiveXObject("Excel.Application");
ExcelSheet = new ActiveXObject("Excel.Sheet");
If i then leave that webpage the Excel application closes. This is what I want.
However when I name my worksheet as follows: -
ExcelSheet.ActiveSheet.Name = "MySheet";
then when I leave the page Excel stays open. Does anyone know how I can name a Worksheet and still have Excel shut when I leave my page?