I want to wite some data in existing excel
workbook from my program i making it with VB6
I have wrtie code like this :
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.Cells(1, 1).Value = “This is column A, row 1”
‘ Save the sheet to C:\test.doc directory.
ExcelSheet.SaveAs “C:\TEST.xls”
‘ Close Excel with the Quit method on the Application object.
ExcelSheet.Application.Quit
‘ Release the object variable.
Set ExcelSheet = Nothing
but it’s not work it’s give me error massge
for this line ExcelSheet.Cells(1, 1).Value = “This is it says the properaty not support
so what can ido to make what i need?