Adding Modules
How do I add a module to a workbook using vba codes?
|
Adding Modules
This should work :D
ActiveWorkbook.VBProject.VBComponents.Add(vbext_ct _StdModule) ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Adding Modules
For additional information, go to Chip Pearson's site
http://www.cpearson.com/excel/vbe.htm -- Regards, Tom Ogilvy "JonWayn" wrote in message . .. How do I add a module to a workbook using vba codes? |
All times are GMT +1. The time now is 08:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com