| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Break a link between workbooks when there is no "break" option | Excel Discussion (Misc queries) | |||
| Closed workbooks still appear in VBE? | Excel Programming | |||
| Information from Closed workbooks | Excel Discussion (Misc queries) | |||
| Referencing Closed workbooks...Help! | Excel Programming | |||
| Get two Values from closed Workbooks | Excel Programming | |||
Linear Mode
