Sort an excel

txantxagorri

Hello,
How can I sort an excel which I export from Nav with Automations?
Thanks!

tinoruijs

Hi,

You could take a look at the following post (I found it by searching the forum ):
http://www.mibuso.com/forum/viewtopic.php?t=18606&highlight=excel+sort

awarn

Um, wouldn't it make sense to sort the data before exporting it?

You could always use a tempoarary table to sort it however you want, then export the temp table, really it shouldn't be more than 10 lines of code...

-a

txantxagorri

why doesn´t apply the sorting to the specified range, it takes also the first line
xlWorkSheet.Range('A2:O600').Sort(xlWorkSheet.Range('I2'));