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?
|