Loop throught closed workbooks and break a specifc Link in each.

  • Thread starter Thread starter Cresta
  • Start date Start date
C

Cresta

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
 
Thanks for your reply. Looks like they are going to have to make a cup of tea
while this loop runs.
 
Back
Top