Hi there,

I have a question which keeps bugging me for a while and nobody can help me with this..

It's about 2 simple excel files, the 1st excel file(tool + sheet 2 = database table) which has a data connection to the 2nd excel file (database table).
When you open the 1st excel file(tool + sheet 2 = database table) it will refresh his database Table(sheet 2) automaticly using VB.
However, this connection remains active in the background so i can not change my 2nd excel file(database) when anyone has the 1st excel file(tool + sheet 2 = database table) open.
Is there a way to close the connection via VB after the refresh (i don't 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 approach?

The 2nd excel file (database table) is a list over 7000 abbreviations and the 1st excel file(tool + sheet 2 = database table) works like a filter -> one cell can be filled in with the abbreviation which gives a result of all the possible meanings.

I would appreciate it a lot if I could borrow an excel goeroe mind for this question

Thanks in advance!

With kind regards,

Christopher Bosch