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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to loop through the Workbook Links 1
execution speed issue when closing files 5
non basic code in call stack 3
All Workbook Saved except This Workbook - Part2 3
Opening a list of Excel files and run a macro in each 17
Close doesn't always close 3
Open and Save Files in Directory 1
How to update all links to other workbooks 6

Back
Top