Thread: Add a VBA Module from a String instead of from a file
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] gimme_this_gimme_that@yahoo.com[_2_] is offline
external usenet poster
  
Posts: 236
Default 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.
Reply With QuoteReply With Quote