Work on excel file from access vba

[Molly Brennholz]

Hi,

...Your doubt about the excel file being really opened, at this point, is not meaningful, because the code in NOT executed,....

Ahh yes, you said compile error in post #1,.. sorry my mistake I over saw that.


I see now what you are saying. I agree with you, that a compile error does seem strange, suggesting that Access does not know about excel things. As I do not have ACCESS I cannot check much further..

---

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)

---

We do not have many ACCESS experts looking in at excelfox.
You could also try asking at these places
https://www.excelforum.com/access-pr...ng-vba-macros/
https://www.mrexcel.com/board/forums...oft-access.18/

Please if you ask at other forums, tell everybody of your posts in other forums so that we can all keep up to date on any developments in getting your problem solved.


Molly