how to find whether linked data exists

[beyond limits]

How do I Find whether an excel workbook contains any links to data in other
excel workbooks programmatically?
Each excel sheet has a property which gives the count of Hyperlinks, but i
was unable to find a property which can suggest whether a workbook contains
data linked to other workbook or not?

 

[Gary Brown]

Check out Bill Manville's FindLink.xla at...
http://www.bmsltd.co.uk/MVP/Default.htm

--
HTH,
Gary Brown
(e-mail address removed)
If this post was helpful to you, please select
''''''''''''''''YES'''''''''''''''' at the bottom of the post.