Creating column names in an Excel ss

[parminderdhiman84]

The error you are getting is because the object is not defined. please define the excel object first. Refer to below code :

Code:

Filename="<your path>"
    Dim objExcel
    Set objExcel = createobject("Excel.application")
    objExcel.DisplayAlerts = False
    Set oBook = objExcel.Workbooks.Open(Filename)
    Set oSheet = objExcel.Activesheet

    objExcel.Cells(1,1).Value = "Row"

    oBook.SaveAs (Filename)
    objExcel.Workbooks.Close()
    Set oSheet=Nothing
    Set oBook=Nothing
    Set objExcel=Nothing

Regards,
Parminder