ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Paste txt to word (https://www.excelbanter.com/excel-programming/312694-paste-txt-word.html)

Daniel Van Eygen

Paste txt to word
 
I have been trying to paste some text into word.

So far I have come up with following code: It copies cells containing text,
opens word and than rings the alarm bell.....

Any further help will be greatly appreciated.
Daniel

Sub CreateNewWordDoc()
ActiveWorkbook.CustomViews("Print").Show
Range("J2:L55").Select
Selection.Copy
Shell "C:\Program Files\Microsoft Office\Office11\WINWORD"
Set wrdApp = CreateObject("Word.Application")
wrdApp.Visible = True
Set wrdDoc = wrdApp.Documents.Add
With wrdDoc
????????Paste???????????
End With
End Sub




All times are GMT +1. The time now is 05:26 PM.

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