Refresh all open workbooks

[dannyok90]

Morning,

Is there some code that can refresh all open workbooks or excel applications that are open?

I have two workbooks linked and when data is input in one and the workbook is closed, id like it to refresh the other open workbook automatically.


preferably id like this to happen without having to reference a file path but rather just update or refresh any other versions of excel I have open at the time?

Cheers,
Danny

 

[Starnub]

This line should work:

For Each wb In Application.Workbooks: wb.RefreshAll: Next wb

You can put this in the "Workbook_BeforeClose" sub of the workbook you close, it will refresh all open workbooks when you close it.

 

[dannyok90]

Cool! I’ll give it a try thankyou!