probably 2 basic for here

[joe]

I am trying to copy data from an email to an excel spread sheet using vb. I
have not been successful either way so I tried to copy from the clipboart to
excel spread sheet just to get ideas and use the macro. When I create the
macro (using the record macro function), the data gets copied and then I use
the text wizard to format the data (it is seperated by spaces). This works
well. When I got to just run the macro, it stops and the data is still in
the raw format. How do I populate the row/cells like it did in the text
wizard? Any help (or code) would be appreciated. Thanks
Joe

 

[BrianB]

1. Cannot answer without seeing your code. If not solved put a new
message with your code (many of us do not read messages with answers).
2. Perhaps you are not *selecting* the data in the worksheet first.
3. Presumably you are using the menu - Data/Text to Columns ?

Regards
BrianB
=================================