View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Adam Adam is offline
external usenet poster
 
Posts: 287
Default How to I put a comma in between each column item from this code

This code combines all the data into one string. How can I parse it with a
comma in between each column entry.

Also would there be a way to add comments to each column right before the
comma?? Thanks

Set x = CreateObject("Word.Application")
x.Documents.Add
x.Visible = True

For Each cl In Selection

n = n & CStr(cl.Value)

Next

x.Selection.TypeText CStr(n)