Add a row to a datatable

[Ankur]

(Or if there is no way of adding a row let me know the adress of the guy who designed that freaking qtp object model?)

LOL

ok, this has to do with excel automation model rather than QTP's automation model. You can write a custom function that opens an external excel workbook , opens a sheet in it and then add the required message in the required cell.

I am providing a function, i wrote sometime back for a similar requirement...hope it will help you get started. You can improvise upon it as per your needs.

Code:

Function PutValueInFile (sfilePath, msg, irow, icolumn,isheet)
   sfilePath = "C:\Test.xls"
   Set ExcelObj = CreateObject("Excel.Application")
   ExcelObj.Workbooks.Open sfilePath
   Set NewSheet = ExcelObj.Sheets.Item(isheet)
   NewSheet.Cells(irow,icolumn) = msg
   ExcelObj.ActiveWorkbook.Save
   ExcelObj.Application.Quit
   Set ExcelObj = Nothing
End Function