Greetings,
I've created a macro that loads data from an external source into a series of sheets and then manipulates and displays it as desired. The problem is the data from the source changes frequently, so I need the macro to refresh that data at short intervals, say every 30 seconds or every minute. I've tried doing this with a loop delayed using the Timer function. This works as far as the refreshing is concerned, but it renders Excel useless as you can't operate it (aside from just watching the screen) while the macro is running.
Are there any better ways to do this? For example is it possible to set the macro to run every minute?
Regards,
Gerald Chappell
I've created a macro that loads data from an external source into a series of sheets and then manipulates and displays it as desired. The problem is the data from the source changes frequently, so I need the macro to refresh that data at short intervals, say every 30 seconds or every minute. I've tried doing this with a loop delayed using the Timer function. This works as far as the refreshing is concerned, but it renders Excel useless as you can't operate it (aside from just watching the screen) while the macro is running.
Are there any better ways to do this? For example is it possible to set the macro to run every minute?
Regards,
Gerald Chappell