Refresh Ms Query Every 30 seconds
 

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

Refresh Ms Query Every 30 seconds
 

OnTime

"Steven Taylor" wrote:
I need some VBA code to refresh this MS query every

30 seconds while the workbook is open.