ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   finding all link, hyperlinks in a workbook (https://www.excelbanter.com/excel-discussion-misc-queries/34717-finding-all-link-hyperlinks-workbook.html)

Michele

finding all link, hyperlinks in a workbook
 
ile:///\\animal\shared\Accounting\DEBBIE '05-'06\ADESOGAN.xls - '61'!A1
this is an example of one of my links inside one of my workbook. it leads to
another page in the same workbook. i have about 26 workbook with about 31
worksheets in each. each workbook is independent of each other, there should
be not link leading out of the workbook itself. i think i may have some links
leading out and i can't locate them. there are so many links in each
workbook. i tried the suggestion of downloading the FINDLINK.xla but it
found no links anywhere in the workbook...lol. just trying to see if there
is a way to look at each link...maybe in a list or something so i can make
sure there is no links leading out of each workbook.

Anne Troy

Hi, Michele. The only thing I'm aware of that does anything like that is
LinkHacker.
http://www.mrexcel.com/sunshop/index...bstart=0&id=11
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Michele" wrote in message
...
ile:///\\animal\shared\Accounting\DEBBIE '05-'06\ADESOGAN.xls - '61'!A1
this is an example of one of my links inside one of my workbook. it leads

to
another page in the same workbook. i have about 26 workbook with about 31
worksheets in each. each workbook is independent of each other, there

should
be not link leading out of the workbook itself. i think i may have some

links
leading out and i can't locate them. there are so many links in each
workbook. i tried the suggestion of downloading the FINDLINK.xla but it
found no links anywhere in the workbook...lol. just trying to see if

there
is a way to look at each link...maybe in a list or something so i can make
sure there is no links leading out of each workbook.




Dave Peterson

You have another reply at your original thread.

Michele wrote:

ile:///\\animal\shared\Accounting\DEBBIE '05-'06\ADESOGAN.xls - '61'!A1
this is an example of one of my links inside one of my workbook. it leads to
another page in the same workbook. i have about 26 workbook with about 31
worksheets in each. each workbook is independent of each other, there should
be not link leading out of the workbook itself. i think i may have some links
leading out and i can't locate them. there are so many links in each
workbook. i tried the suggestion of downloading the FINDLINK.xla but it
found no links anywhere in the workbook...lol. just trying to see if there
is a way to look at each link...maybe in a list or something so i can make
sure there is no links leading out of each workbook.


--

Dave Peterson


All times are GMT +1. The time now is 02:17 AM.

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