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,


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!