| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
| Excel Seems to Refresh every 5 seconds | Excel Discussion (Misc queries) | |||
| Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) | |||
| Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
| Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False) | Excel Programming | |||
Linear Mode
