Word 2003 and Excel formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bremser - 26 Mar 2008 16:31 GMT

I'm creating an Excel-based order form. I'm trying to copy and paste a
2-page word document (contract text) into 2 contiguous worksheets in Excel.
The first page comes over fine. However, when I copy and paste the second
page, the numbering reverts back to 1 (instead of the 5 that starts that
page).

How can I keep the numbering scheme when copying over to Excel?

Thanks!

Bremser

Reply to this Message

Anubix - 27 Mar 2008 17:40 GMT

Wasn't able to replicate the problem. but, it sounds like Excel is not
keeping the autonumbering setup in Word. Can you convert the numbers
to plain text? I have a macro that will do it. First, Save your
document as a new one for testing purposes. Then, select the whole
thing and apply this macro:

Sub ConvertNumberingtoText()
'

' converst automatic numbering to text
'
Dim lp As Paragraph
For Each lp In activedocument.ListParagraphs
lp.Range.ListFormat.ConvertNumbersToText
Next lp

End Sub

On Mar 26, 11:31 am, Bremser <Brem...@discussions.microsoft.com>
wrote:

> I'm creating an Excel-based order form. I'm trying to copy and paste a
> 2-page word document (contract text) into 2 contiguous worksheets in Excel.
[quoted text clipped - 7 lines]
>
> Bremser

Reply to this Message

Rate this thread: