Add a VBA Module from a String instead of from a file

[gimme_this_gimme_that]

If I have

Dim v as String
v = "Sub test() " + chr(10) + "MsgBox 33333" + chr(10) + "End Sub"

Is there a way to add a new module and insert the Sub test from the
string variable v ?

Thanks.

 

[RB Smissaert]

I don't think there will be any problem with that.
If there is then write the string to a file first.
Read this: http://www.cpearson.com/excel/vbe.aspx

RBS