Unlink Saved Copy of Original Workbook

The code below creates a copy of the original workbook but only contains specific sheets. The saved name is created from the code but allows the user to select what folder and path they prefer. The saved copy contains links that requires the user when opening the copy to select update or ignore. I would like to remove any links when its saved and eliminate this popup when users open the file. I tried inerting the ListObject.Unlink command, but no luck. Can someone help me with this?

Please Login or Register  to view this content.

Thanks for the code. I tried inserting it at various locations and always get a type mismatch error on the For x=1 to Ubound(arLinks) line. The arLLinks variable always shows as empty. I don't think it's picking up the workbook? Do I need to set a dimension for the workbook?

Hi Richard
Yes the original workbook contains links that i dont want to break. I just want to break links in the copy back to the original. The copy is is used throuout the business and while most won;t update , some may ty to. I'll test this new line of code

Thank You for the help on this