Using String as Code for new Module
 

Use continuation characters _ which is a space and an underscore

xxxxxxxxxxx _
yyyyyyyy _
zzzzzz

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"TFriis" wrote in message
...
I have a loooong txt string containg code as one long continous line.

IE.

str = "sub newFunction dim i as integer, test as integer test = 0 for
i = 1 to i=1000 test=test+i next i end sub"

Just much much longer.

My issue is that I use this string as code for a new module - how do I
auto-convert my stringed code to something VB can read? - My string is
so long, that it cuts it (when max contents of a line is reached), and
therefore it cant interpretate/read the content.