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 Autpen()
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
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 Autpen()
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