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

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
 
C

Cresta

Thanks for your reply. Looks like they are going to have to make a cup of tea
while this loop runs.
 

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

Loop through workbooks and worksheets in each workbook 1
execution speed issue when closing files 5
How could I split a spreadsheet containing 600 rows, so there's 100rows in each new workbook 6
Excel Formula to add network file link to each month 1
non basic code in call stack 3
Copy from closed excel file and paste to master file then loop for same siles 2
Weird ignoring of one item in a loop 5
Opening a list of Excel files and run a macro in each 17

Top