I have a file that is linked to some other files. I need to open all of the linked files, because sometimes they're not updated. How can I do that?
If I could get a collection with the paths to all the linked files, then I can open them and update them with others objects that I already have. In VBA it's something like:
collection = ThisWorkbook.LinkSources(xlExcelLinks)
If I could get a collection with the paths to all the linked files, then I can open them and update them with others objects that I already have. In VBA it's something like:
collection = ThisWorkbook.LinkSources(xlExcelLinks)