[RESOLVED] [VBA in Access and Excel] Two modules with same name

[ActSciMan]

I'm working on improving some VBA code in Excel, but the only time it's ever run is during the process of a huge macro in Access (the macro opens the Excel file and runs the macro in Excel and the Access macro does a bunch of stuff before and after). In Access, we have the following code:

Set ObjXLApp = CreateObject("excel.application")
Set objXLBook = ObjXLApp.workbooks.Open("whatever.xls")
ObjXLApp.Visible = True
ObjXLApp.Run ("SomeMacro")
ObjXLApp.Quit

My question is, which version of SomeMacro is run if the Excel workbook has two different modules with this name? They do basically the same thing, but I just want to know which one I can delete out. One is in the code for a worksheet, one is in a module, so my guess is the one in the module is the one that is run. Am I right? Thanks for any help!

Oh, similar question. In the Access file, there are three modules each with a function: Public Function getPath() As String
Which one is run when it's called? It is called only in the three modules that it is in. So, does it default to using the one in the same module? The code is all exactly the same, so again, not real important, but I'm trying to clean things up a bit.