Convert Word Document into Excel with Word Hierarchy

[xiazai0003]

Hi Guys,

Try to convert my Word Document into Excel with Property Word Hierarchy

For Example, In Word Document

1. Heading 1
1.1 Heading 1.1
The first paragraph xxxxxxx
The second paragraph xxxxxx

2. Heading 2
Another Paragraph
2.1 Heading 2.1
One more Paragraph

I want to convert this document into Excel with following format. Just wonder can anyone help with that? or any clues?

[macropod]

Did you want to run this macro from Word or from Excel?

[macropod]

Cross-posted at: http://www.vbaexpress.com/forum/show...with-Hierarchy & http://www.vbaexpress.com/forum/show...Word-Hierarchy
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

Kindly provide cross-posts link in both your threads at VBA Express.

[xiazai0003]

Originally Posted by macropod

Did you want to run this macro from Word or from Excel?

Yes, just find something works in WORD to convert a document to Excel with Hierarchy

[macropod]

I see that you have still not had the courtesy to provide a cross-post link at VBA Express. Until you do, there will be no progress here.

[Guessed]

Basic workflow would be to use a macro to:
- For each paragraph: If outline level = body text then add two tabs in front of paragraph
- Convert automatic numbers to hard coded
- Convert entire doc to table (using tabs as separators)
- Paste into Excel

[xiazai0003]

Originally Posted by macropod

I see that you have still not had the courtesy to provide a cross-post link at VBA Express. Until you do, there will be no progress here.

Sorry for that, Newbie for forum and did not realize there is a rule for that. Want to update my original Post but there is no 'Edit' button

[macropod]

Originally Posted by xiazai0003

Want to update my original Post but there is no 'Edit' button

You could just post a reply there, with a link to this thread...

[xiazai0003]

Here are two cross links

1.http://www.vbaexpress.com/forum/show...Word-Hierarchy

2.http://www.vbaexpress.com/forum/show...with-Hierarchy

Originally Posted by xiazai0003

Hi Guys,

Try to convert my Word Document into Excel with Property Word Hierarchy

For Example, In Word Document

1. Heading 1
1.1 Heading 1.1
The first paragraph xxxxxxx
The second paragraph xxxxxx

2. Heading 2
Another Paragraph
2.1 Heading 2.1
One more Paragraph

I want to convert this document into Excel with following format. Just wonder can anyone help with that? or any clues?

[xiazai0003]

Thanks, just start to learn VBA...

Originally Posted by Guessed

Basic workflow would be to use a macro to:
- For each paragraph: If outline level = body text then add two tabs in front of paragraph
- Convert automatic numbers to hard coded
- Convert entire doc to table (using tabs as separators)
- Paste into Excel

[xiazai0003]

Originally Posted by macropod

You could just post a reply there, with a link to this thread...

Thanks!~~~~~~~~

[macropod]

You still haven't posted your cross-post thinks to this thread at VBA express. Kindly do so.