Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove active module in a copy
I have a workbook with one module and i want to save a copy of workbook
without this module. Plaese help me to write codes to do this automaticaly. Thanks Mehrdad Hakimzadeh |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove active module in a copy
Here's a function
'---------------------------------------------------------------- Function DeleteModule(moduleName As String) '---------------------------------------------------------------- Dim vbMod As Object Set vbMod = ActiveWorkbook.VBProject.VBComponents(moduleName) ThisWorkbook.VBProject.VBComponents.Remove vbMod End Function -- HTH RP (remove nothere from the email address if mailing direct) "Mehrdad Hakimzadeh" <Mehrdad wrote in message ... I have a workbook with one module and i want to save a copy of workbook without this module. Plaese help me to write codes to do this automaticaly. Thanks Mehrdad Hakimzadeh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove Protected Macro Code from Excel Module | Excel Discussion (Misc queries) | |||
HOW TO COPY 480 ACTIVE E-MAIL ADDRESSES CLM "G" ON AN ACTIVE EXCE. | Excel Discussion (Misc queries) | |||
Active VBE Module ? | Excel Programming | |||
Remove VBA Project module | Excel Programming | |||
Remove VB Module from workbook | Excel Programming |