View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ruud van Deursen Ruud van Deursen is offline
external usenet poster
 
Posts: 2
Default SORTING AFTER AUTOMATED REFRESHING OF DATA

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