Running Access Macros or Code from Excel Module

[Bass71]

Hi;

I know I can open an MS Access db from code generated in excel, but can I also run a macro and or code respective to the db, from the excel macro as well?

Thanks.............

 

[xlbo]

yup - once access is open, it opens it's object model up therefore you can use the docmd.runmacro command within the code....

Rgds, Geoff
[blue]Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?[/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244