Hi Perry,

This cannot be done. When you run VBA code in MDB files the code is complied on the fly into, not machine code, but some other language that I can't remember the name of. It's like .NET code, which is compiled into IL, which is compiled again into machine code when its ran. VBA is the same, it's compiled into something I can't remember the name of, which is then compiled into machine code when it's ran.

When you make a MDE file the VBA code is compiled and stored in the database as the language I can't remember the name of which makes things run faster but it means you cannot edit it or export it, because it's no longer VBA.