UFT-Editing Excel Which is connected to server and with plugin is not wortking
We need to work on the already existing excel and edit values in the rows.
But the methods of writing into rows is not working through QTP but the same works fine manually. When we try to edit the rows it shows an error saying “pivot table can’t change values”
Note : This excel is loaded with an plugin which makes the excel to connect to X server and gets related data. And we can edit this only when its connected to server.
Please let me know code to an already opened excel by considering the factor mentioned in Note.
How are you opening the file? Post the code you are using
Thanks for the reply Tarun , I am using the below code :
strpath = "C:\Shashi Scripts\KarthikExcel.xls"
Set objExcel = GetObject("","Excel.Application")
Set objWorkBook = objExcel.Workbooks.Open (strpath)''already opened file
Set objWorksheet = objExcel.ActiveWorkbook.Worksheets(1)
objWorksheet.Cells(1, 1).Value = "ABCD"
i will get the error at last 2 lines ...
Tags for this Thread