Posted to microsoft.public.excel.worksheet.functions

Chris Youlden Chris Youlden is offline

external usenet poster

Posts: 5

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto Refresh	RobGTP	Excel Discussion (Misc queries)	0	September 29th 07 06:21 AM
Auto refresh	[email protected]	Excel Worksheet Functions	1	October 27th 06 09:41 PM
auto refresh	Lou Sanderson	Excel Worksheet Functions	2	August 17th 06 05:45 PM
How can I auto-refresh auto-filters when data changes?	Mike@MPWco	Excel Worksheet Functions	0	July 4th 06 12:50 PM
Auto-Refresh	gregory.barrett	Excel Discussion (Misc queries)	0	March 29th 06 06:54 PM

All times are GMT +1. The time now is 01:46 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us