| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to add New Module through coding
I am trying the following but getting error messages, please help
Sub AddModule() Dim VBComp As VBComponent Set VBComp = ThisWorkbook.VBProject.VBComponents.Add(vbext_ct_S tdModule) VBComp.Name = "NewModule" Application.Visible = True End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replacing a module by coding in VBA | Excel Programming | |||
| Coding to remove and import Module | Excel Programming | |||
| Implant macro coding into ASP coding | Excel Programming | |||
| Run worksheet module code from workbook module? | Excel Programming | |||
| Variable from a sheet module in a class module in XL XP | Excel Programming | |||
Threaded Mode
