Can anybody tell me the meaning of following syntax.
Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
Dim oSheet As Excel.Worksheet
Dim oRng As Excel.Range
Set oXL = CreateObject("excel.application")
oXL.Visible = True
Set oWB = oXL.Workbooks.Add
Set oSheet = oWB.ActiveSheet
' Add table headers going cell by cell.
oSheet.Cells(1, 1).Value = "First Name"
I dont want to create new excel object but want to open existing file for writing into it.
please help me out.
Thanks