Solved: Macro extract external links from Edit>Links and update

[mccannf]

I thought I had posted a new version, but it seems not

Hello there,

I would like to get a copy of the add-in you posted in this thread, but I don't see it online. I think the add-in would be very useful for me. Are attachments removed after a certain period of time?

Thanks,
Francis.

[Bob Phillips]

It seems they don't. I cannot recall this thread, so I am not sure what the addin did, and I cannot find it on my systems I am afraid.

[mccannf]

It seems they don't. I cannot recall this thread, so I am not sure what the addin did, and I cannot find it on my systems I am afraid.

OK, thanks for your reply. I will ask xluser2007 for a copy.

[mccannf]

Hi Bob,

That was legendary, was that just a days work for you!

Exactly what I require. I'll now have a play as to the second part of my problem which is manually listing the update links in column B and writing a macro to change source (Column A) to target (Column B). Will keep you posted with any queries on this when they arise.

Thanks again, coming to this forum makes the improbable possible!

regards

Hello there,

I would like to get a copy of the add-in that was posted for you by XLD in this thread, but I don't see it online. I think the add-in would be very useful for me. Are attachments removed after a certain period of time?

Thanks,
Francis.

[xluser2007]

Hi mccannff,

I'm about to head on leave and thought I'd reply quickly to attach (the 'very Disctinguished') Bob's addin that he provided for me.

This is used to list the external links to the workbook.

Cheers,

xluser2007

[Bob Phillips]

I'm about to head on leave...

Have fun, wherever you go.

[mccannf]

Hi mccannff,

I'm about to head on leave and thought I'd reply quickly to attach (the 'very Disctinguished') Bob's addin that he provided for me.

This is used to list the external links to the workbook.

Cheers,

xluser2007

Hi xluser2007,

Thank you very much for your reply with the add-in.

Enjoy your holidays.

Francis.

[gw55]

Hi All,

I think as logic is concerened the macro is fine, all it doing is the following:

[VBA]ActiveWorkbook.ChangeLink "c:\excel\book1.xls", _
"c:\excel\book2.xls", xlExcelLinks[/VBA]


The only issue, is that my workbooks have the same name but different paths e.g:

[VBA] ActiveWorkbook.ChangeLink "c:\excel\book1.xls", _
"c:\excel_folder_different\book1.xls", xlExcelLinks [/VBA]

that is the folders are different, but the booknames are not i.e. book1.xls.

Could anyone please explaina the workaround for this situation?

regards

[Bob Phillips]

What is it you want to do, change the path of the links in your workbook?

[gw55]

What is it you want to do, change the path of the links in your workbook?

I need to change my current links to the new sources links.

For example: Current Links to ten worksheets in one folder, new links will be in another folders but name changes. Thanks!

[mmcgowan1]

Hello!

Is this Addin available anywhere? It really sounds like it will suit my needs!

Thanks!

Mark

[Bob Phillips]

It is not readily available, the forum deletes files after a while, and I cannot recall what I did in the addin, nor can I put my hands on a copy. Maybe xluser2007 is still around reading these, and still has a copy.