Sending XL data to work bookmark

N

nickadeemus2002

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help pasting usedrange in word bookmark 0
Excel-->Word Copy/Paste Range @ Bookmark 5
Delete bookmark when checkbox value is false 3
Excel automation: How to access XL sheet as the second task? 7
Selection vs Range 5
Open Method fails on Error 5174 0
Undo is being cancelled by a call to bookmark? 1
exporting data to appear at Bookmarks in a Word Document 0

Top