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.

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


<(E-Mail Removed)> wrote in message
news:dd5269e5-fff9-4585-9146-(E-Mail Removed)...
> 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.