How to Export VBA Code to a text file

Discussion in 'Access VBA Modules' started by Danny, Jun 1, 2010.

  1. Danny

    Danny Guest

    Howdy.

    Is there a built-in function for exporting ALL VBA code in a database to a
    text file? I can do it for each VBA object - form, report, and module - but
    this takes a long time.

    Thanks.

    Danny
     
    Danny, Jun 1, 2010
    #1
    1. Advertisements

  2. Not a built-in function, but it's pretty easy to write code to do it.

    See, for example, http://www.vb123.com/kb/200502_ds_saveas.htm

    --
    Doug Steele, Microsoft Access MVP
    http://www.AccessMVP.com/DJSteele
    Co-author: Access 2010 Solutions, published by Wiley
    (no e-mails, please!)

    "Danny" <> wrote in message
    news:...
    > Howdy.
    >
    > Is there a built-in function for exporting ALL VBA code in a database to a
    > text file? I can do it for each VBA object - form, report, and module -
    > but
    > this takes a long time.
    >
    > Thanks.
    >
    > Danny
     
    Douglas J. Steele, Jun 1, 2010
    #2
    1. Advertisements

  3. Danny

    Danny Guest

    Thanks Doug. Works beautifully. Wonderful enhancement suggestion: Export ONLY
    VBA code behind forms and reports.

    Cheers.

    "Douglas J. Steele" wrote:

    > Not a built-in function, but it's pretty easy to write code to do it.
    >
    > See, for example, http://www.vb123.com/kb/200502_ds_saveas.htm
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://www.AccessMVP.com/DJSteele
    > Co-author: Access 2010 Solutions, published by Wiley
    > (no e-mails, please!)
    >
    > "Danny" <> wrote in message
    > news:...
    > > Howdy.
    > >
    > > Is there a built-in function for exporting ALL VBA code in a database to a
    > > text file? I can do it for each VBA object - form, report, and module -
    > > but
    > > this takes a long time.
    > >
    > > Thanks.
    > >
    > > Danny

    >
    >
    > .
    >
     
    Danny, Jun 1, 2010
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.