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

I'm not sure I understand why you are asking for code to do this... find the
module name in the Project list, right-click it and select Export File from
the popup menu that appears... you can choose whatever destination you want
for the exported copy of the module and, if desired, you can even change the
name for the exported file. Actually, you can do this for any of the sheets,
modules or even UserForms listed in the Project window.

--
Rick (MVP - Excel)


"Roger" wrote in message
...
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

I know how to import/export modules manually - if I update my code in my
master file - I then distibute it to end users - doing things manually is
always subject to human error - if you write code & check that it works - it
always works with no human error - that is why i made the request

"Rick Rothstein" wrote:

I'm not sure I understand why you are asking for code to do this... find the
module name in the Project list, right-click it and select Export File from
the popup menu that appears... you can choose whatever destination you want
for the exported copy of the module and, if desired, you can even change the
name for the exported file. Actually, you can do this for any of the sheets,
modules or even UserForms listed in the Project window.

--
Rick (MVP - Excel)


"Roger" wrote in message
...
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

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

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

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