Refresh Ms Query Every 30 seconds

S

Steven Taylor

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refresh an Access Query using VBA code in Excel 6
Link, drop link, relink 2
Query Table Performance 1
vba code does not run 3
Auto Refresh Query Table 4
Workbook Open bypasses Query Refresh 3
Refresh Query Table causing debug error with Background Refresh pr 2
External Data refreshment 2

Top