Get the list of external links

[Venkat]

Is there any way to get the list of external links referred by a workbook?
Normally, we get this list by using Edit->Links in Microsoft excel. But I
want to know the list of external links by programmatically.



Thanks in advance.



Cheers,

Venkat

 

[Dave Peterson]

Take a look at VBA's help for LinkSources. There is sample code there.