J
JohnUK
Hi,
I need a piece of code that refreshes external data repeatedly without
having the dialouge box appear each time. I have used:
ActiveWorkbook.RefreshAll and the Application.DisplayAlerts = False
but the box still appears each time ready for me to press the OK (just what
I dont need seeing that there are 31 refreshes at roughly 8 second intervalls.
Any help greatly appreciated
PS I posted this earlier under the General (Oops)
I need a piece of code that refreshes external data repeatedly without
having the dialouge box appear each time. I have used:
ActiveWorkbook.RefreshAll and the Application.DisplayAlerts = False
but the box still appears each time ready for me to press the OK (just what
I dont need seeing that there are 31 refreshes at roughly 8 second intervalls.
Any help greatly appreciated
PS I posted this earlier under the General (Oops)