Easy way to Export Modules?

[ahjeck]

Hi, in Access (2003)(VB) there's an export feature to export module/macro code onto text. Unfortunately there is no easy way to export all modules/macros at once.

Further more, macros need to be converted to VBA code first, then exported.

Is there a wizard or some sort that does this all at once?

Suggestions comments appreciated. Thanks!

 

[Bodisathva]

not for multiple macros, but you can right-click on a macro and save as a module. I suppose if one were inclined, they could employ the same strategy using a for-each loop...

 

[ahjeck]

Yah, basically that's what I've been doing (the manual export). Mmm, write code to transfer...not a bad idea. I'll think about it thanks!

 

[KeithG]

You can use the Docmd.OutPutTo method to export you modules. You can loop through the Module Collection to retrive all module names.