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

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.

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

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


wrote in message
...
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.