List links (via function)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Johannes van der Pol - 24 Nov 2004 09:55 GMT

Hello all,

Is there a way to show the (full) name of links in a range of cells. I know
you can do this manually with "findlink", but am looking for a way that on
my "master print" also the name of all linked workbooks is shown.

Thanks in advance,

Johannes

Reply to this Message

Bill Manville - 24 Nov 2004 16:51 GMT

> Is there a way to show the (full) name of links in a range of cells. I know
> you can do this manually with "findlink", but am looking for a way that on
> my "master print" also the name of all linked workbooks is shown.

You could write a VBA function to do it or you can use a defined name.

Insert / Name / Define / MyLinks RefersTo:=TRANSPOSE(LINKS(,1))

Then in a worksheet, select cells in a column equal in number to the number
of Excel links in the workbook and enter =MyLinks as an array formula
(Ctrl+Shift+Enter)

If you also have DDE links you can do a similar trick using LINKS(,2)

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply to this Message

Johannes - 25 Nov 2004 08:31 GMT

Cool, a lot easier than I thought.

Thanks,

Johannes

> > Is there a way to show the (full) name of links in a range of cells. I know
> > you can do this manually with "findlink", but am looking for a way that on
[quoted text clipped - 13 lines]
> MVP - Microsoft Excel, Oxford, England
> No email replies please - respond to newsgroup

Reply to this Message