Login or sign up Lost password?
Login or sign up
You may also want to read: Excel VBA refresh all Pivot Table or Pivot Cache Excel VBA Ask To Update Links Property First of all, to refresh closed workbook involves opening the workbook, refresh and then close it, it is impossible to refresh closed workbook without opening it, but we can open a workbook by vba w Public Sub refresh XLS() Dim fso As Object Dim folder As Object Dim file As Object Path = "C:\Users\WYMAN\Desktop\folder\" Set fso = Create Object("Scripting.