Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help pasting usedrange in word bookmark
Hello all. I keep getting a Runtime Error 13 Type mismatch for th
following code: code: -------------------------------------------------------------------------------- Public Sub SendToWord() Dim CAP As Range Dim myWord As Word.Application Set CAP = Sheets("InitialAssessments").UsedRange CAP.Copy Set myWord = New Word.Application With myWord .Visible = True .Activate myWord.Documents.Open _ Filename:="C:\Documents and Settings\chrisv\Desktop\HBC2\Repor Document\HBC Reporting Document.doc" With Selection myWord.ActiveDocument.Bookmarks("InitialAssessment s").Select .Item("InitialAssessments").Range.Text = CAP.PasteSpecia <-----PROBLEM WITH THIS LINE End With End With End Sub -------------------------------------------------------------------------------- I am trying to copy a used range in Excel and copy it at the 'Initia Assessments' Bookmark in Word. Suggestions?? And as always, thanks for the hel -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink to Word / HTLM bookmark in Excel 2007 | Excel Discussion (Misc queries) | |||
hyperlinking from an Excel cell to a bookmark in Word | Excel Discussion (Misc queries) | |||
linking to a bookmark in a Word doc | Excel Discussion (Misc queries) | |||
hyperlink from Excel to a Word bookmark | Excel Discussion (Misc queries) | |||
to pull in metadata from another system (like bookmark in word) | Excel Discussion (Misc queries) |