Work on excel file from access vba

[roberto21]

Hi,

---

How do you call this macro ?
What I mean is ….. I have used the calling macro
Sub CallSubAggiornaLibroSoci()
to set off Private Sub AggiornaLibroSoci(NTes As String)


What do you do to set off Private Sub AggiornaLibroSoci(NTes As String)

---

Molly

I am not sure aouyr what you are asking. Anyhow, the code used to call the sub follows

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

in the same module as the sub. This is the code activated when the user clicks on the Save button in access form: as I said, in certain cases I need to update the excel file.


Thanks for the suggestion. I will try to explain the problem in other forums, and I'll keep you informed. Thanks again