Hello there
I'm working on an automation task. So basically i have a folder containing mutliple workbooks with heavy dependencies. I would like to perform a filecopy to a new directory then break all the links so that i can work on them independently. Problem is that only works for some files with the other giving me an Error and not breaking links. Is there an effcient to break all links using VBA. I'd prefer for the user not to have break the links manually since it can be quite annoying.
Thanks in advance
I'm working on an automation task. So basically i have a folder containing mutliple workbooks with heavy dependencies. I would like to perform a filecopy to a new directory then break all the links so that i can work on them independently. Problem is that only works for some files with the other giving me an Error and not breaking links. Is there an effcient to break all links using VBA. I'd prefer for the user not to have break the links manually since it can be quite annoying.
Thanks in advance