View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ed[_18_] Ed[_18_] is offline
external usenet poster
 
Posts: 118
Default VBA excel paste to word deleting itself

Hi, Skyron. You didn't post any code, but from your description and my
experiences (as a head-scratcher trying to figure out what I'm doing!), it
sounds like you're not moving the Selection off what you have just pasted
into Word. If it's still selected in Word, then the next thing you try to
insert or paste will replace your selection. Without seeing the code, it's
hard to recommend anything, but off the top of my head I'd suggest a
Selection.Collapse wdCollapseEnd, which will collapse the selection in Word
(note the "wd") to the end.

HTH
Ed

"Skyron " wrote in message
...
Hey guys

I've tried pasting cells to word both using

wrddoc.content.paste

and

wrddoc.content.pasteexceltable false false false

and I'm doing something wrong after that because I can't seem to insert
a page break, text or anything after that without delete the data.

I'd appreciate some help!


Ok, that wasn't exactly descrictive, sorry guys.

I'm trying to cut and paste some cells from excel to word, insert a
page break and repeat the process on a new page.

Does anyone know how to get this done?

Thanks!!!

(Nigel, kkknei, Bob, and Juan, thanks for your help earlier)


---
Message posted from http://www.ExcelForum.com/