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

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

Hi Cresta

No you must loop and open

See
http://www.rondebruin.nl/copy4.htm

You can add code from this page in the red part
http://www.rondebruin.nl/values.htm
Last macro on the page

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Cresta" wrote in message ...
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

Loop throught closed workbooks and break a specifc Link in eac
 

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

"Ron de Bruin" wrote:

Hi Cresta

No you must loop and open

See
http://www.rondebruin.nl/copy4.htm

You can add code from this page in the red part
http://www.rondebruin.nl/values.htm
Last macro on the page

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Cresta" wrote in message ...
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