how to delete row from the runtime Datatable

S

sweta26_kum

hi ,
i have created a Excel sheet in the QTP script by using createobject
method . Now there is anther script where i have to retrive the value
of each row from that excel sheet and delete it .since i am able to
retrive the value from the excel sheet but cant delete the whole row ..
please help me
i m sending you the code for the retriving the row values ...

Dim objExcel, strPathExcel,strCN
Dim objSheet, intRow

intRow = 6
Set objExcel = CreateObject("Excel.Application")
strPathExcel = "C:\ALTable1\tablew13 July.xls"
objExcel.Workbooks.open strPathExcel
Set objSheet = objExcel.ActiveWorkbook.Worksheets(1)
'Do Until objExcel.Cells(intRow,1).Value = ""
strCN1 = Trim(objSheet.Cells(intRow, 1).Value)
msgbox strCN1
strCN = Trim(objSheet.Cells(intRow, 2).Value)
msgbox strCN
strCN2 = Trim(objSheet.Cells(intRow, 3).Value)
msgBox strCN2



PLEASE HELP ME AS SOON AS POSSIBLE
thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vbscript to open worksheet, insert data on first opencell....HELP..... 2
Attempting to use VBA to Ping within Excel... 6
Ping from Excel - Almost there 3
Excel hangs 1
Need assistance with secondary axis in Excel 2007 0
excel data into access 3
Error 0x800A03EC when trying to populate a worksheet 3
VB Scrpit to input search results in Excel work book 0

Top