Using With and Module to access variables, macros, functions in another module

[JimminyJim]

As per the heading: I'm trying to access variables, macros, functions in another module

I know that I can use (if calling from Module 1):

Module2.variable
Module2.sub
Module2.function

(assuming declared as public)

But how can i use 'With' statement to access multiple?

I've tried:

Dim myMod As VBIDE.VBComponent
Set myMod = ThisWorkbook.VBProject.VBComponents("Module2")

With myMod
   .variable = 15
   .sub
   .function
End With

I get "Object doesn't support this property or method" on each line item after 'With myMod'. Yes I have the extensibility library loaded.

This example might seem trivial, but in my actual project I wish to access many different variables and functions in many different modules to do bulk data retrieval and writing.

Is there something I can use to identify a module that can be used in a WITH statement?

 

[JimminyJim]

Sorry RoryA, yes good point on the why!

I AM duplicating function names in multiple modules(intentionally), so I need to explicitly determine the module.

The need is twofold:
1) Remove code duplication (my last post)
2) Set the module to call at run time

 

[RoryA]

It sounds like you should be using classes then. It's not going to work with normal modules.