Copy Word Range to Excel

[MikeZz]

I've seen a lot on this subject but nothing for my specific application.

I have a word document with a lot of formated text & tables.
I've been able to find the start and end of a range I want to copy back to
excel.
Assuming start = 100, end = 250

How do I copy the range from word to excel with the following considerations:
1. I'd like to maintain the formatting (bold text etc...) if possible.
2. When I manually copy word.range and paste it into excel, it has a heavy
black line which I don't want to come across..... ie how can I copy the rich
text range without the line object?

I am doing the VBA in an Excel Workbook (v2003) and I haven't done much VBA
in Word so please be as complete as possible.

Thanks for any help,
MikeZz

 

[Cindy M.]

Hi Mike,

I've seen a lot on this subject but nothing for my specific application.

I have a word document with a lot of formated text & tables.
I've been able to find the start and end of a range I want to copy back to
excel.
Assuming start = 100, end = 250

How do I copy the range from word to excel with the following considerations:
1. I'd like to maintain the formatting (bold text etc...) if possible.
2. When I manually copy word.range and paste it into excel, it has a heavy
black line which I don't want to come across..... ie how can I copy the rich
text range without the line object?

I am doing the VBA in an Excel Workbook (v2003) and I haven't done much VBA
in Word so please be as complete as possible.

I think the first thing you need to do is discover the origin of this line that
you don't want. Is it in the Word document? Or is it something that's appearing
when you paste into Excel?

What is this pasting as? A Word OLE object? (Excel handles it like a graphic,
but if you double-click you can edit in Word.) Or something else?

If the line is on the graphic object, can you remove it using drawing tools?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail