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

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.
Similar Threads
  1. Katrina
    Replies:
    4
    Views:
    193
    Katrina
    Jan 23, 2004
  2. Nagendra Singh Dhakar via AccessMonster.com

    how to export a text file to ansys and text file to structure

    Nagendra Singh Dhakar via AccessMonster.com, Apr 2, 2005, in forum: Access VBA Modules
    Replies:
    1
    Views:
    151
    Larry Linson
    Apr 2, 2005
  3. make a VBA to export pivot chart to word

    how to create a VBA code to export pivot chart to word

    make a VBA to export pivot chart to word, Aug 31, 2005, in forum: Access VBA Modules
    Replies:
    0
    Views:
    167
    make a VBA to export pivot chart to word
    Aug 31, 2005
  4. binar

    Text File Export VBA Script Help Please

    binar, Oct 20, 2007, in forum: Access VBA Modules
    Replies:
    2
    Views:
    165
    John Nurick
    Oct 20, 2007
  5. AccessARS

    Find retrieve text from a text file through VBA

    AccessARS, Feb 8, 2008, in forum: Access VBA Modules
    Replies:
    0
    Views:
    113
    AccessARS
    Feb 8, 2008
  6. efandango
    Replies:
    6
    Views:
    263
    Douglas J. Steele
    Oct 5, 2008
  7. Gary
    Replies:
    10
    Views:
    239
    AccessVandal via AccessMonster.com
    Jan 27, 2010
  8. Jack
    Replies:
    1
    Views:
    214
    PieterLinden via AccessMonster.com
    May 5, 2010
Loading...