Excel - Get paths to linked files (LinkSources)

Digital_WorkerB — Sat, 17 Oct 2020 08:00:00 GMT

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)

Edit: I can open the linked table list using Alt+E+K, but I don't think that's useful if any code stage can be programmed

--------------------------------------------------
Disclaimer: This content was auto-posted from Stackoverflow. The original Stackoverflow question is here Stackoverflow Post, posted by Dylan.

RE: Excel - Get paths to linked files (LinkSources)

NileshJadhavBP — Mon, 19 Oct 2020 22:34:00 GMT

Hi,

You can use below VBA code as requested. I have created and tested

Prerequisite - Excel workbook should have some excel linked.

Sub DisplayLinkStatus()

Dim NewColl As New Collection

LinkSources = ThisWorkbook.LinkSources(xlExcelLinks)
If IsArray(LinkSources) Then
For Each link In LinkSources
'NewColl.Add link
Debug.Print link
Next
End If
End Sub

If you find your ans please click on best answer button,

Thanks
Nilesh

------------------------------
Nilesh Jadhav
Senior RPA Specialist
ADP
------------------------------

topic Excel - Get paths to linked files (LinkSources) in Product Forum

Excel - Get paths to linked files (LinkSources)

RE: Excel - Get paths to linked files (LinkSources)