0

Is it possible to call a function in one stand-alone Access VBA program (with its own UI) from another stand-alone Access VBA program (with its own UI). I know how to do this to invoke a function in WORD, but, in this case, my own Access VBA program would take the place of WORD.

braX
  • 11,506
  • 5
  • 20
  • 33
Bill Edwards
  • 9
  • 7
  • 1
    Does this answer your question? [Using a centralized VBA module in multiple Access databases](https://stackoverflow.com/questions/4168674/using-a-centralized-vba-module-in-multiple-access-databases) Or this https://stackoverflow.com/questions/48319539/call-a-sub-from-a-subroutine-in-another-access-database Or https://stackoverflow.com/questions/1455829/calling-function-in-one-mdb-from-another-mdb – June7 Mar 29 '20 at 18:28
  • Fantastic! Just what I needed. Thank you for the quick response. When I saw your answer, I was deep in the weeds reading how to create COM interfaces, which was getting very complicated. Thank you, thank you, thank you! Question: How do I give credit for this to you? – Bill Edwards Mar 30 '20 at 21:42
  • No credit if I don't write an answer and since there are already adequate answers, I am not doing another. I expect this question will eventually get closed because it is a duplicate. – June7 Mar 30 '20 at 21:45

0 Answers0