External Links

[Libra0099]

Dear All,

Good day!

Is there any utility which can name the file along with its path where my desired excel file (Current file) is linked.

OR I can also rephrase the requirement as below:

Name of the files (along with their path) which are fed by my current excel file


Thanks

 

[Trevor G]

I dont understand your question properly.

The following will give you the workbook path and name

=CELL("filename")

Does this help?

 

[technicalupload]

Hi
Could you please re-pharse your question?

Thanks

 

[dk]

Hi

Are you talking about external Excel links? If so then this macro may provide what you need:

Sub ListExternalLinks()
    Dim shtOutput As Worksheet
    Dim arrLinks As Variant
    Dim lArrIndex As Long



    arrLinks = ActiveWorkbook.LinkSources(xlExcelLinks)

    'If there is at least one external link then output them to a worksheet
    If Not IsEmpty(arrLinks) Then

        Set shtOutput = Worksheets.Add
        shtOutput.Range("A1").Value = "External Links within this workbook"
        shtOutput.Range("A3").Value = "File Path"

        For lArrIndex = 1 To UBound(arrLinks)

            shtOutput.Range("A" & lArrIndex + 3).Value = arrLinks(lArrIndex)

        Next lArrIndex

        shtOutput.Range("A2:" & shtOutput.UsedRange.SpecialCells(xlCellTypeLastCell).Address).Columns.AutoFit

    Else

        MsgBox "Active workbook contains no external Excel links.", vbInformation, "No External Links"

    End If



End Sub

If the active workbook contains any links to external Excel workbooks then this macro will list them. Note that you can also get this information by choosing Edit, Links in Excel 2003 or prior, or by choosing Data, Edit Links in Excel 2007 onwards (I guess that you already know this )

HTH
DK

 

[Libra0099]

dear all,

thanks for giving time.

My requirement is to find out the files which are reading from my current file.

For example... I am working on file A. I want to know data from file is floating to File B, C, X, Z etc

From Edit links I can get information that from which file data is coming in.. But I want to know where current file's data is going OUT.

I hope you will understand my situation.

 

[Andrew Poulsom]

Sorry, there is no way of doing that.

 

[Libra0099]

Dear All,

Thank you very much for your time and replies.

Have a great day