Unable delete row from excel file in QC from QTP
I am automating a test scenerio where I have to delete a Xl sheet row . This excel sheet is in QC.
I am trying to access the Excel by adding the QC folder in QTP->options->folders
I am deleting the row through my code and when i save the file. the temp file created in my local folder while executiion, is getting updated not the one in QC.
here is the code i am using :
Set Xlobj = CreateObject ("Excel.Application")
Set Xlbk = Xlobj.Workbooks.Open(x)
Set Xlst = Xlbk.Activesheet
Please let me know how do i update the Xl file which is in QC.
Re: Unable delete row from excel file in QC from QTP
Use: Set Xlst = Xlbk.Activesheet
instead of: Set Xlst = oBook.Activesheet
you don't have oBook defined in your code.