Opening a file with external data sources using VBA & saving, ensuring that these connections aren't broken or corrupted

  • Hi Everyone,


    So I recently noticed that when I open a file using Workbooks.Open method which has external connections, the connection becomes corrupt or breaks. Does anyone know why this happens/is there a way around it? I want to open the file with external connections, fill in some information & save as a new name & loop through a variable. I will place the code here:

    The code above works fine, except the fact it appears to break the connections.


    I could not find anything relevant online.


    Please help!


    Thank you in advance,


    Mel