| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Running a macro from an auto-refresh
I have a worksheet that imports data using a data query from an Access
database. The external data range properties are set to auto refresh the data every 5 minutes. Is there a way for the data refresh to automatically run a macro every time it occurs? TIA -- Chris |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Running a macro from an auto-refresh
Use an OnTome event to run every 5 minutes as well, but set to run say 5
seconds after the query refresh. -- Gary''s Student - gsnu2007 "Chris Youlden" wrote: I have a worksheet that imports data using a data query from an Access database. The external data range properties are set to auto refresh the data every 5 minutes. Is there a way for the data refresh to automatically run a macro every time it occurs? TIA -- Chris |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Running a macro from an auto-refresh
Gary''s Student wrote:
Use an OnTome event to run every 5 minutes as well, but set to run say 5 seconds after the query refresh. Excellent - thanks. I'll give it a go. Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Refresh | Excel Discussion (Misc queries) | |||
| Auto refresh | Excel Worksheet Functions | |||
| auto refresh | Excel Worksheet Functions | |||
| How can I auto-refresh auto-filters when data changes? | Excel Worksheet Functions | |||
| Auto-Refresh | Excel Discussion (Misc queries) | |||
Linear Mode
