Hi All,



I would appreciate some help with the following.



I have an excel workbook within which I have a MS query

linked to an excel database. The name of the query is

TM1.



I need some VBA code to refresh this MS query every

30 seconds while the workbook is open.



All comments and suggestions are welcome.



Thanks,



Steve