Call Excel macro from Access module?

[sabavno]

Hello,

I was wondering if anyone could tell me how to call if it is possible the macro from within the Access module.

Thanks.

 

[lespaul]

Take your Excel Application object and :

ExcelApp.Run('MACRONAME')

HTH

Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!

 

[nashman]

Don't want to be sacrilegious but you can check out this link...

http://www.mvps.org/access/modules/mdl0007.htm