View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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.