How to add module in Visual Basic With Excel?


--
Sathisc
------------------------------------------------------------------------
Sathisc's Profile: http://www.thecodecage.com/forumz/member.php?userid=187
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=87929

manually? in the code editor (the IDE) - you can open it with Ctrl+F11
from the Insert menu, select Module


"Sathisc" wrote:


How to add module in Visual Basic With Excel?


--
Sathisc
------------------------------------------------------------------------
Sathisc's Profile: http://www.thecodecage.com/forumz/member.php?userid=187
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=87929

Are you looking for this... Launch VBE using Alt+F11. Insert module

If this post helps click Yes
---------------
Jacob Skaria


"Sathisc" wrote:


How to add module in Visual Basic With Excel?


--
Sathisc
------------------------------------------------------------------------
Sathisc's Profile: http://www.thecodecage.com/forumz/member.php?userid=187
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=87929

if you want to do it in code, its also relatively straightforwards...


Sub AddAModule()
Dim md As Object
Dim wb As Workbook
Set wb = Workbooks.Add

' you can (a) programatically add a module
Set md = wb.VBProject.VBComponents.Add(1)

and also (b) import a text file as a module
Set md = wb.VBProject.VBComponents.Import("{full address here}")

With md

'blah

End With

End Sub


"Sathisc" wrote:


How to add module in Visual Basic With Excel?


--
Sathisc
------------------------------------------------------------------------
Sathisc's Profile: http://www.thecodecage.com/forumz/member.php?userid=187
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=87929