
Problem with "Excel.Sheet"
Hello all,
I picked from JScript Language Reference an example of creating and using
Excel sheet from a script.
In all its simplicity the script excerpt is below:
var ExcelSheet;
ExcelSheet = new ActiveXObject("Excel.Sheet");
ExcelSheet.Application.Visible = true;
ExcelSheet.ActiveSheet.Cells(1,1).Value = "Hello";
ExcelSheet.SaveAs("C:\\XLSTEST.XLS");
ExcelSheet.Application.Quit();
ExcelSheet = "";
Now when I run the script and if I have Excel running, I can see a sheet
'Object' to appear when the ActiveXObject is created. However the next two
lines in the script example cause error: 'Object doesn't support current
locale setting'.
I have IE 4.0 -or should I call it IE 4.01- version 4.72.2106.8 and I have
installed MS Scripting 3.1 to it. Microsoft Excel is version 7.0.
Can anyone tell me what is wrong with this?