Save only the code from a Sheet?

[christopher.allen]

Hi,

How do I save only the code from a sheet? I've been slogging through
the VBA ref docs and the web (and this place!) but haven't been able to
find this. Thanks!

-Christopher

 

[Bob Phillips]

Go to the VBIDE, select the code module, and File>Export it.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[christopher.allen]

I meant programmatically. I tried recording a macro and doing what you
said, but I can't record from the VB editor.

 

[Bob Phillips]

ThisWorkbook.VBProject.VBComponents("Module1").Export ("C:\module1.bas")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)