Save only the code from a Sheet?
 

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

Save only the code from a Sheet?
 

Go to the VBIDE, select the code module, and FileExport it.

--
HTH

Bob

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

"christopher.allen" <"at workscape.com" wrote in message
...
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

Save only the code from a Sheet?
 

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

Bob Phillips wrote:
Go to the VBIDE, select the code module, and FileExport it.

Save only the code from a Sheet?
 

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

--
HTH

Bob

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

"christopher.allen" <"at workscape.com" wrote in message
...
I meant programmatically. I tried recording a macro and doing what you
said, but I can't record from the VB editor.

Bob Phillips wrote:
Go to the VBIDE, select the code module, and FileExport it.