Hi, you can use Range method to get the data from excel instead of Cell Method.
e.g: Set xl2 = xl.Workbooks.Open(Cstr(Source_File)) xl2.Worksheets(Cstr(Source_Sheet)).usedrange.Copy you can find some more related useful code in below link. keep a post if you don't find exact required code. I'll send you appropriate code. http://qtptesters.blogspot.ca/2012/03/copy-excel-sheet-content-into-another.html regards, Baba Fakruddin D On Apr 5, 5:11 am, omkar <[email protected]> wrote: > Hi guys, > > How can I retrieve data from a row(in excel sheet). > > I don't want to use "*cells*" object to get the data one by one. > > very Urgent !! > > Thanks in advance ! > -- > Thanks & Regards, > Omkar Deekonda -- You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en
