Thread
:
Using String as Code for new Module
View Single Post
#
1
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett