Work on excel file from access vba

[Molly Brennholz]

..., the code used to call the sub follows

If NDescrizione = "Quote associative di rinnovo" Then
Call AggiornaLibroSoci(Me.Tessera)
End If
...

OK, that answers my question. Thanks

---

Another possibility:-
If you can solve the problem of opening an Excel file with ACCESS, then we can arrange that a macro already inside the Excel file starts when the Excel file is opened.
( I am not sure how you would transfer the information .... (Me.Tessera)
One possibility could be to put it in the Clipboard from ACCESS, then retrieve it from the Clipboard from Excel.
I have done this putting in and retrieving from Excel. Possibly the coding is the same in ACCESS. I am not sure. )

I do not know why you are experiencing problems in opening an Excel File from ACCESS.
Here for example, it is suggested that it can be done: http://www.vbaexpress.com/kb/getarticle.php?kb_id=527 .

Hopefully an ACCESS expert might have a better idea and can help you further