Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Custom sort -Excel Sheet
#1
Not Solved
I want to apply custom sort on option for more than 4 levels , currently i am able to apply only on till three levels i.e as follows using following


Code:
Set objWorkbook = objExcel.Workbooks.Open("C:\EXCEL.xls")
Set objWorksheet = objWorkbook.Worksheets(1)
Set objRange = objWorksheet.UsedRange
Set objRange2 = objExcel.Range("A1")
Set objRange3 = objExcel.Range("B1")
Set objRange4 = objExcel.Range("C1")
Set objRange5 = objExcel.Range("D1")

objRange.Sort objRange2,xlDescending,objRange3, ,xlAscending,objRange4,xlDescending,xlYes

But using above code i am able to apply code only till three levels.I want to known how to apply sort on excels sheet for more than 3 levels .

Thanks
KK
Reply


Messages In This Thread
Custom sort -Excel Sheet - by kiran - 01-27-2014, 09:14 PM
RE: Custom sort -Excel Sheet - by supputuri - 01-28-2014, 09:23 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Windows Application Custom Combo box selection change event not firing in uft RamUFT 0 959 02-06-2020, 08:10 AM
Last Post: RamUFT
  Trying to create List box in excel sheet at Run time with values yes No JACKSPARROW 0 1,706 01-17-2017, 11:05 AM
Last Post: JACKSPARROW
  Can we save an exported Excel sheet directly from QTP? Akhila 2 3,452 11-28-2013, 10:30 AM
Last Post: Akhila
  How to identify the object reference to the existing(already opened) Excel sheet yogeesh 1 9,949 09-26-2012, 07:00 PM
Last Post: krr
  How to sort different dates in and get the Max date from those nilanjans 2 5,686 09-07-2012, 07:35 AM
Last Post: vIns

Forum Jump:


Users browsing this thread: 3 Guest(s)