Macro to update links once data copied

[howard]

I open a workbook that has links to another workbook and do not update the links when prompted


I have a macro to copies the data to another row. I need a macro that will update all the links after the macro has run


Your assistance is most appreciated

 

[Kamolga]

Would not

ActiveWorkbook.RefreshAll

at the end of your code do it?

Otherwise if you are in Book1 and want to update the links to book2, you can use

ActiveWorkbook.UpdateLink Name:="C:\Users\You\Desktop\Book2.xlsx", Type:=xlExcelLinks

 

[howard]

Thanks for the help

 ActiveWorkbook.RefreshAll

updates the links