Running Acces Macro/Module from VB

[RobertMottram]

What I want to be able to do is run a Macro or module writen in Access in VB.
Does anyone know how this is done.
From what I can see it probably has something to do with application.access, but I know no more then that!

Thanks for any help you can give

Rob

 

[RFletch]

just type
docmd.runmacro "macroname"

RFletch

 

[RobertMottram]

Sorry, I want to run the macro or good from a VB program not from access VBA. This will not be able to work as I have not told VB what database to open so it can not be able to run the macro.
I know that this will work from an access module (ie VBA)

Rob