Hi,

very noob into excel and Access

I have 2 access files and 2 excel files.

Access#1 extract data from server with some conditions (was not able to set it properly in excel)
excel #1 extract the data from the access than execute macro to clean data; runs 24/7
access#2 extracts data from Excel #1
Excel #2 opened by a second user

I need the data from excel #1 into excel #2. They will be opened by 2 different users. So I used access#2 to extract excel #1 and then excel #2 as I didn't know any way not to crash my macro in excel #1

When I open my excel #2, the excel #1 opens. I don't want that. There is some code to execute a determined time and it reopens the excel #1 each time

How can I get rid of excel #1 from user #2 session?

If you were able to follow that, do you have a lean solution for that?
thanks!