VBScript problem - MS Excel

[Kim]

Hi,
I copied the following code from Microsoft and pasted it into a "Run Script" function in "Visual Build Professional" v5.0. When testing the script, Error at Line 4, Column 1 occur.

What am I doing wrong?

------CODE--------------------------------------------------------------------
' VBScript source code

Dim ExcelSheet
Set ExcelSheet = CreateObject("Excel.Sheet")

' Make Excel visible through the Application object.
ExcelSheet.Application.Visible = True

' Place some text in the first cell of the sheet.
ExcelSheet.ActiveSheet.Cells(1,1).Value = "This is column A, row 1"

' Save the sheet.
ExcelSheet.SaveAs "C:\DOCS\TEST.XLS"

' Close Excel with the Quit method on the Application object.
ExcelSheet.Application.Quit

' Release the object variable.
Set ExcelSheet = Nothing

[kalons]

This code also fails on by box if you put it in a .vbs file and execute via cscript/wscript, it's not specific to VisBuildPro. Sounds like the code is wrong or a required component isn't installed.

[Kim]

Then my question is: How do I write a script that would create a specifyed object?