Hi,

Do you have you final code that works?
I've been trying but it returns error messages all over the code.
thanks

"Roger" wrote:

Joel - thanks - i butchered a section of Chips code - the solution is below
and now you see it, its remarkably simple - thanks again

Activeworkbook.VBProject.VBComponents("Mod1").Expo rt
Filename:="C:\F&I\Mod1,bas"



"Joel" wrote:

See cpearson website

http://www.cpearson.com/Excel/vbe.aspx

The macros that copy from one workbook to another exports the VBA code into
a BAS file (text). You want to save the BAS files. Yo don't need to use the
import code.

"Roger" wrote:

Could someone give me an example of the code required to export a code module
to a folder (for Back up)

I can export from 1 file to another - but am struggling with the above

Assume the workbook that I want to export from is called "File1"
the module I want to export is called "Mod1"
the back up directory is called "C:\F&I\Backup|"

thankyou in anticipation