Hi,

I have a question that Google didn't answer, nor did the numerous PDF I
have
about excel programming, and of course, nor did my boss ;)


Here you go!


I have an Excel 2003 workbook with a sheet.
I have a user form.
I have a TextBox in that user form.
I also have a text file outside of Excel.


When I copy paste manually the text file into any cell in the sheet,
the
text file gets spreads onto the cells pretty good - You know, most of
the
data has its own cell, etc., it looks decent enough to attempt to write
a
parser -by the way, my boss told me "its either write a parser or
parse the
327 word doc manually into excel" so of course, I feel constrained
to ask for
help ...

The problem arise when I have the text file pasted into the user form
text
box and then try to have a macro do some parsing. You see, the user
gets to
paste from the windows clipboard (in this case a 327 page word doc that
I
pasted into a text file first) into the user form textbox, and then
press the
Parse! button. The button calls a Parse macro that I wrote in another
module.


But when the textbox.text gets copied into a cell with code like ...

myTemp.Range(A7).Value = sData

All the text gets fitted into one cell.


I am trying to reproduce the effect that I get when I manually copy a
text
file into a cell : it gets spread into many cells more or less in a
readable
fashion.

So my Question is: How do I achieve this effect in coding?

Thank you for your help, kindly,

Antoine Dubuc
Best Buy For Business :)


--
BBFB
------------------------------------------------------------------------
BBFB's Profile: http://www.excelforum.com/member.php...o&userid=26344
View this thread: http://www.excelforum.com/showthread...hreadid=396092