View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kaiser kaiser is offline
external usenet poster
 
Posts: 23
Default Exporting excel cell contents to word document

Hello,

How do I export a cells contents to a specific word file as a new line?
I also want to be able to label each line with a counter.

Say for example my cells value is "cell value" and my word file is
"destination.doc" I want to be able to do something like


counter = 1
Do until activecell.value = empty
{"destination.doc" value = counter &
activecell.value}
{new line so that next string isnt added to end of prev string in
word doc}

activecell.offset(1,0).select
Loop


Any ideas?