Getting Error for Sorting Column in Pivot table

Help Studio
, ,
1

I have used a VB code and that is giving me error .
image
Can anyone suggest me what should I do?

2

Hi @Kunal_Jain

Can you show the code here?

Regards
Sudharsan

3

Hi @Sudharsan_Ka
Sub SortPivotColumn()
Dim PT As PivotTable
Set PT = ActiveSheet.PivotTables(“YourPivotTableName”)
With PT.PivotFields(“YourColumnFieldName”)
.Orientation = xlRowField
.Position = 1
.SortOnValue = True
.SortOrder = xlDescending
End With
End Sub
Please find the code

4

Hi,
I think ‘SortOnValue’ and ‘SortOrder’ are no methods or properties of ‘PivotField’ object. Perhaps you could try ‘AutoSort’- method instead.

Regards, Uwe

5

what is this??

6

Hi,
read the documentation:

Regards, Uwe

7

With Worksheets(1).PivotTables(1).PivotFields(“product”)
Select Case .AutoSortOrder
Case xlManual
aso = “manual”
Case xlAscending
aso = “ascending”
Case xlDescending
aso = “descending”
End Select
MsgBox " sorted in " & aso & _
" order by " & .AutoSortField
End With

I am using this code
what should I give here for worksheet and pivot tables
as my worksheet is “Material” pivot table is 6

8

Hi,
this is a new problem. So I think the first problem is solved.

According to your first listing:
ActiveSheet.PivotTables(“YourPivotTableName”).PivotFields(“YourColumnFieldName”)

or

Worksheets(“Material”).PivotTables(6).PivotFields(“product”)

Regards, Uwe

9

Hi @UBur
Can you just help me with the txt file that I need to pass on Invoke VBA activity.

10

Hi,
sorry, but i’m not interested.

But look here:
Read hyperlink from Excel without URL - Help / Studio - UiPath Community Forum

Regards, Uwe

11

ok thank you !!