Module In Visual Basic

[Sathisc]

How to add module in Visual Basic With Excel?

 

[Patrick Molloy]

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

 

[Jacob Skaria]

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

If this post helps click Yes

 

[Patrick Molloy]

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