VBS writing to excel file

C

carmen

Im using a vbs script to write data to a excell file but keep getting the
fillowing error.Unknown error Code 800A03EC. I know the script will work as
it has workeb before when small amounts of data are added to a xls file.
Are their any limitations to how much data can be added to a cell?

Thanks
carmen

The error is in this section of code.
Do While status = 1
row = row+1
for column = 2 to numcolumns
excelcolumn=column - 1
ExcelSheet.Application.Cells(row, excelcolumn).Value =
oResultSet.GetColumnValue(column) --This line has the error
next
status = oResultSet.MoveNext
numrows = numrows + 1
Loop
 
Top