hello.

in my file (Excel) there are several items (records) that are linked to
external

source files,I like to find one list that tell me each record is linked to
which external

file name.

Thanks in advanced

Masoud,
Is this what you mean ?

Dim HLink As Hyperlink

For Each HLink In Worksheets(1).Hyperlinks
Debug.Print HLink.Address
Next

NickHK

"Masoud" <(E-Mail Removed)> wrote in message
news51F6D3A-5A65-492D-8F21-(E-Mail Removed)...
> hello.
>
> in my file (Excel) there are several items (records) that are linked to
> external
>
> source files,I like to find one list that tell me each record is linked to
> which external
>
> file name.
>
> Thanks in advanced