| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
| VBA code to save excel sheet | Excel Discussion (Misc queries) | |||
| Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use: | Excel Programming | |||
| Placing a code before Save & Save As | Excel Programming | |||
| Solver code does not save results to sheet - What am I missing?! | Excel Programming | |||
Linear Mode
