Opening an excel file which has a query to external data

[pedro]

I have an access application which opens an excel file which has a
query to that access application to import data.

* I open the excel file when the access application is closed, i get
the message "this workbook contains etc ... Enable automatic refresh".
Until here everything works as expected and the data is refreshed
fine.

* When I open the excel file when the access application is opened i
get the message that the db is opened exclusively by another user.
This I understand ass well, but is it possible to resolve this?

* Now the thing I'm looking for is: Is it possible to open the excel
file with vba code in de access application and make it refresh itself
even if the access application is still open ??

Thanks in advance.