Sending XL data to work bookmark
 

Good afternoon.
I am trying to send the used range in an Excel worksheet into a wor
bookmark. Here's what I have:


Code
-------------------
Public Sub SendToWord(
-------------------


I keep getting a Runtime Error 5174 on this line of code:
Documents.Open Filename:="C:\Documents an
Settings\chrisv\Desktop\HBC2\ Report Document.doc"

Is it bad syntax, or am I not giving necessary arguments.

All help appreciate

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