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

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" <Danny@discussions.microsoft.com> wrote in message 
news:BC54AA01-7E51-4EB2-8EA0-A3818BAB0D8C@microsoft.com...
> 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 

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" <Danny@discussions.microsoft.com> wrote in message 
> news:BC54AA01-7E51-4EB2-8EA0-A3818BAB0D8C@microsoft.com...
> > 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 
> 
> 
> .
>