View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cresta Cresta is offline
external usenet poster
 
Posts: 76
Default Loop throught closed workbooks and break a specifc Link in each.

Hello
I have many xls files that have a Link to a common workbook.

Is it possible to loop through each file and break the links to the common
file, without opening each file.

I can loop through each file and open them up but it is taking a very long
time to complete all the files. Plus this routine needs to be run frequently,
which won't please the end user.

Many Thanks