Refresh All Question

DarrenF

Board Regular
Joined
Jun 9, 2014
Messages
77
Hello,

When I use the below Macro and I open any other workbook when I have my 'CS Tech Cases - Bothell' book open it will try and refresh other workbooks as well. Is there a way that I can only have it refresh the 'CS Tech Cases - Bothell' and no other workbooks opened? I thought having "Workbooks ("CS Tech Cases - Bothell").RefreshAll" would specify just the one workbook, but it's not working.

Private Sub Auto_Open()
my_onTime
my_Procedure
End Sub


Sub my_onTime()
Application.OnTime Now + TimeValue("00:01:00"), "my_Procedure"
End Sub


Sub my_Procedure()
Workbooks("CS Tech Cases - Bothell").RefreshAll
my_onTime
End Sub
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Watch MrExcel Video

Forum statistics

Threads
1,109,013
Messages
5,526,268
Members
409,689
Latest member
martin_br

This Week's Hot Topics

Top