run module code from macro

[C Holmes]

This relates to access 2000. I have written some code in a module (it's
purpose is to clean up data in a .csv file prior to importing it into the
database) which I would like to be able to run from a access macro. Is this
possible? I see that there is a "OpenModule" option from the macro dropdown
list. But is there a way to just run the procedure from the macro?

Thanks in advance.

 

[Ken Snell [MVP]]

The procedure that you want to run must be a Public Function. You run it
from the macro using RunCode.

 

[C Holmes]

Thanks Ken, works great.

The procedure that you want to run must be a Public Function. You run it
from the macro using RunCode.