Problem with "Excel.Sheet" 
Author Message
 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?



Sun, 25 Mar 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. CreateObject("Excel.Sheet")

2. CreateObject("Excel.Sheet")

3. CreateObject("Excel","//server"), MsgBox output

4. CreateObject("Excel.Application") problem

5. Problem With "window.showmodaldialog("")"

6. color PS "test sheet" wanted

7. CreateObject("Excel.Application") Error

8. CreateObject("Excel.Application")

9. CreateObject("Excel.Application")

10. Setting "Subject" in Excel via vbs

11. "subscript out of range" - Excel

12. Response.contenttype = "application/vnd.ms-excel"

 

 
Powered by phpBB® Forum Software