Call an Access macro from an Excel macro
 

I have a macro in an Access database that I would like to call in a macro I'm
creating for excel. How do I do that? And is it possible to do without
opening Access?

Call an Access macro from an Excel macro
 

Hi Jason,

I don't believe you can call it without opening Access although you can open
an instance of Access from Excel with displaying it. It is possible to write
code in Excel the manipulates Access using its object model. I believe, to
do that you will need to reference its library in Excel and to do that in the
VBE you would choose Tools, References, and check Microsoft Access X library.

You might also post to the Access Database newsgroup.

--
Cheers,
Shane Devenshire
Microsoft Excel MVP

"Jason W" wrote:

I have a macro in an Access database that I would like to call in a macro I'm
creating for excel. How do I do that? And is it possible to do without
opening Access?