If you are getting your data through get exteral
data/micorsoft query, there is a sort in mirosoft query.
click any cell inside the query range then on the menu bar
date get external data edit query. a wizard will
appear. the sort criterial in on the third sheet.

-----Original Message-----
In Excel i have a query with an automatic refreshrate
from 10 minutes. The data wich is imported in an
excelsheet is coming from a *.txt file.
In excel the data must be sorted al the time in column B.
Everytime after refreshing automatically i have to sort
again manual. Is there a way in VB to handle this also
automaticaly. Now i have a button for it with a macro.

Thank yoy so much
.