ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Insert a line in word from excel (https://www.excelbanter.com/excel-programming/311297-insert-line-word-excel.html)

Mark

Insert a line in word from excel
 
I am using Office 97, I am in the process of writing code which exports
pictures form excel to word with the following code

With wrdDoc

.Content.PasteSpecial Link:=False,
DataType:=wdPasteMetafilePicture, _
Placement:=wdFloatOverText, DisplayAsIcon:=False

End With

But I can't get WORD to move down a line leaving the picture where it has
been pasted so I can paste the next picture in!

I have tried

Selection.EndKey Unit:=wdStory

but it doesn't work

Can anyone assist, please?


--
Mark

rog

Insert a line in word from excel
 
Not sure what kind of object your wrdDoc is, but you could
try :

wrdDoc.TypeParagraph

(I just recorded this in word)

Rgds

Rog

-----Original Message-----
I am using Office 97, I am in the process of writing code

which exports
pictures form excel to word with the following code

With wrdDoc

.Content.PasteSpecial Link:=False,
DataType:=wdPasteMetafilePicture, _
Placement:=wdFloatOverText,

DisplayAsIcon:=False

End With

But I can't get WORD to move down a line leaving the

picture where it has
been pasted so I can paste the next picture in!

I have tried

Selection.EndKey Unit:=wdStory

but it doesn't work

Can anyone assist, please?


--
Mark
.



All times are GMT +1. The time now is 10:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com