run module code from macro


C

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.
 
Ad

Advertisements

K

Ken Snell [MVP]

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

Advertisements

C

C Holmes

Thanks Ken, works great.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top