Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Module not file when open the excel file | Excel Discussion (Misc queries) | |||
Use String from another module | Excel Programming | |||
Save File without VB Module | Excel Programming | |||
Copy module from one file to another | Excel Programming | |||
Excel VBA to search all macro code in Excel module for specific string criteria | Excel Programming |