Thread: Identifying cells with external links using VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
  
Posts: 2,824
Default Identifying cells with external links using VBA
Maybe you could just look through the cells with formulas that have .xls in them
(or the square bracket character ([) as long as it's not used as text!)

But I'd really use Bill Manville's findlink.zip from:
http://www.BMSLtd.co.uk/MVP/Default.htm

Mark Jarvis wrote:

I want to be able to identify cells in a spreadsheet that
contain formulas with links to other workbooks.

Does anybody know how to use VBA to do this?

Cheers,

Mark

--

Dave Peterson

Reply With QuoteReply With Quote