Hi there,

It's about a simple excel file which has a data connection to another excel file (database table).
When you open the first excel file it will refresh automaticly using VB.
However, this connection remains active in the background so i can not change my database when anyone has the first file open.
Is there a way to close the connection via VB after the refresh (i dont find anything about it, i do find a "ActiveWorkbook.Connections(1).Remove" but this will remove the connection permenantly) or am i just completely doing it wrong and would i be better take an whole other aproach?

Please bear with me i'm a newbie

With kind regards,

Christopher Bosch