ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to find whether linked data exists (https://www.excelbanter.com/excel-programming/407311-how-find-whether-linked-data-exists.html)

beyond limits

how to find whether linked data exists
 
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

how to find whether linked data exists
 
Check out Bill Manville's FindLink.xla at...
http://www.bmsltd.co.uk/MVP/Default.htm

--
HTH,
Gary Brown

If this post was helpful to you, please select
''''''''''''''''YES'''''''''''''''' at the bottom of the post.



"beyond limits" wrote:

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?



All times are GMT +1. The time now is 03:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com