Solved: How to locate link by VBA

[Digita]

Guys,

I'm working on an existing workbook. When I open it I got a message saying "This workbook contains automatic links to information in another workbook. Do you want to update this workbook with changes made in the other workbook?". I couldn't work out this problem as I had an eye check and could not locate any hyperlinks or formula references to any external excel files. :banghead:

Would there be some way to double check this by using a VBA code - ie list out all links?

Thanks & regards


kp

[Jan Karel Pieterse]

Use findlink by Bill Manville: www.oaltd.co.uk/mvp

[jammer6_9]

.

[jammer6_9]

This is perfect!:clap:


Use findlink by Bill Manville: www.oaltd.co.uk/mvp (http://www.oaltd.co.uk/mvp)

[Digita]

Thanks so much Jan Karel Pieterse. That's exactly what i'm after.

Regards

kp