If the Query is done with VBA then put the sort code at the end of the query
code. If not queried with code, then put your sort code in that worksheet's
code under Private Sub Worksheet_SelectionChange(ByVal Target As Range).
When any cell on that sheet changes value, your sort code will run.
Mike F
"Ruud van Deursen" wrote in 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