How to sort a column (Price) from an excel file?


#1

I’m really lost on how to sort a single column in my excel file to ascending and print the LOWEST price out through a message box

… I tried the “Sort data table” but didnt work. I couldnt use “Sort data” because i have no “Table name” in my excel file so that is out of the question (probably).

Any advice?


#2

@Ibra Follow below link


#3

That query the other guy replied with doesnt work.


#4

Maybe sort the column in excel before reading it ?
Or read range, sort, write in excel?


#5

sort

This worked for me…
(The first assign in the To its written “ebayData.DefaultView.Sort”