Export All Modules In Current Project

  • I know this is an old thread but Just to give my 2 cents..


    Top code is a simple code that I wrote and slapped together from many places.


    Remember to enable reference to Microsoft Visual Basic for Applications Extensibility 5.3





    Then there is the overkill way :) that also saves other objects, and opens explorer to where the files were saved, I also took some code and modified it however and updated the commenting pretty robust.

  • Re: Export All Modules In Current Project


    It's the same one for Access as is for Excel


    Microsoft Visual Basic for Applications Extensibility

    Hi,

    i have "Microsoft Visual Basic for Applications Extensibility" enabled but i am getting this error:

    Method 'Export' of object'_VBComponent' Failed

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!