View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Kris Taylor Kris Taylor is offline
external usenet poster
 
Posts: 18
Default Copy And Paste From Excel To Word

Dave Peterson wrote in message ...
this is the copy|paste stuff:

.Selection.GoTo What:=wdGoToBookmark, Name:="OnCor"
.Selection.TypeText Text:=ws.cells(r,2).value

Inside the VBE:
tools|references
scroll down the list looking for:
Microsoft Word xx.x Object Library

But Debra responded to your other post, too.



Kris Taylor wrote:

Dave,

Thanks for the reply!!!

Sadly,I'm still having problems though...

I'm using Excel and Word 97, and I can't seem to find the required
reference. This is what I think the problem is. I do not have a
Microsoft Word reference anywhere in that reference list.

Also, it seems that there isn't a copy/paste feature in the code of
this macro. I could be wrong.

Anyways, I look forward to your future support!

Thanks in advance,

Kris Taylor
www.questofages.org


Hi Dave,

I realized that I was looking in the wrong program for the reference.
I was looking in Excel instead of Word. Anyways, that was already
implemented from prior macro creation.

I also didn't realize that Developper's Dex has some sort of link with
Google and I apologize for double posting. I run my own forums and I
know what kind of a hassle that can be :)

Anyways, Debra's code still hasn't worked for me. Please review my
post in the other thread if you can add anything further!