PDA

View Full Version : Select Folder and Break External Links of All Files



asample57
07-21-2017, 10:49 AM
have been asked to write code to allow the user to:

1) Select the Folder
2) Loop through all folder in the directory and break external links
3) Save and close the files after breaking links.

Any help on how to get started on this would be great. I have searched multiple forums with some success on breaking code in the ActiveSheet, but no idea how to do in on multiple files.

snb
07-21-2017, 12:43 PM
crossposted: https://www.excelguru.ca/forums/showthread.php?8089-Select-Folder-and-Break-External-Links-of-All-Files