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

[roberto21]

I found the solution to the problem of excel opening in read only mode. It was obvious, as are many solutions AFTER you have found them. It was also written in my first post: the table is linked to the access app, therefore the workbook is to be considered open. When I try to open it again with workbooks.open, excel can only open it in read-only mode. One may complain "why didn't excel say so, that the file was already open"? This I don't know, and would like to know.
Anyhow, I replaced

DoCmd.TransferSpreadsheet acLink,...
with
DoCmd.TransferSpreadsheet acImport, ...

and now the .xlsm file opens correctly in read/write. Thank you everybody for your attention and interest. Now, if I or you could find the reason why xlValues is not recognized by the compiler, even though
it is correctly listed in the object browser...