View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel Van Eygen Daniel Van Eygen is offline
external usenet poster
 
Posts: 9
Default 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