Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Convert Word Document into Excel with Word Hierarchy
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 06-01-2016, 06:49 PM
xiazai0003 xiazai0003 is offline Convert Word Document into Excel with Word Hierarchy Windows 7 64bit Convert Word Document into Excel with Word Hierarchy Office 2010 64bit
Novice
Convert Word Document into Excel with Word Hierarchy 		 
Join Date: Jun 2016
Posts: 6
xiazai0003 is on a distinguished road
Default Convert Word Document into Excel with Word Hierarchy
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?
Last edited by xiazai0003; 06-01-2016 at 07:14 PM. Reason: Formatting is wrong
Reply With Quote
  #2  
Old 06-03-2016, 02:25 AM
macropod's Avatar
macropod macropod is offline Convert Word Document into Excel with Word Hierarchy Windows 7 64bit Convert Word Document into Excel with Word Hierarchy Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,501
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Did you want to run this macro from Word or from Excel?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 06-03-2016, 04:36 AM
macropod's Avatar
macropod macropod is offline Convert Word Document into Excel with Word Hierarchy Windows 7 64bit Convert Word Document into Excel with Word Hierarchy Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,501
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 06-05-2016, 06:26 PM
xiazai0003 xiazai0003 is offline Convert Word Document into Excel with Word Hierarchy Windows 7 64bit Convert Word Document into Excel with Word Hierarchy Office 2010 64bit
Novice
Convert Word Document into Excel with Word Hierarchy 		 
Join Date: Jun 2016
Posts: 6
xiazai0003 is on a distinguished road
Default
Quote:
Originally Posted by macropod View Post
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
Reply With Quote
  #5  
Old 06-06-2016, 03:46 PM
macropod's Avatar
macropod macropod is offline Convert Word Document into Excel with Word Hierarchy Windows 7 64bit Convert Word Document into Excel with Word Hierarchy Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,501
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 06-06-2016, 04:25 PM
Guessed's Avatar
Guessed Guessed is offline Convert Word Document into Excel with Word Hierarchy Windows 10 Convert Word Document into Excel with Word Hierarchy Office 2013
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,182
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
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
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #7  
Old 06-14-2016, 08:33 PM
xiazai0003 xiazai0003 is offline Convert Word Document into Excel with Word Hierarchy Windows 7 64bit Convert Word Document into Excel with Word Hierarchy Office 2010 64bit
Novice
Convert Word Document into Excel with Word Hierarchy 		 
Join Date: Jun 2016
Posts: 6
xiazai0003 is on a distinguished road
Default
Quote:
Originally Posted by macropod View Post
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
Reply With Quote
  #8  
Old 06-15-2016, 07:47 PM
macropod's Avatar
macropod macropod is offline Convert Word Document into Excel with Word Hierarchy Windows 7 64bit Convert Word Document into Excel with Word Hierarchy Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,501
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Quote:
Originally Posted by xiazai0003 View Post
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...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 06-19-2016, 04:54 PM
xiazai0003 xiazai0003 is offline Convert Word Document into Excel with Word Hierarchy Windows 7 64bit Convert Word Document into Excel with Word Hierarchy Office 2010 64bit
Novice
Convert Word Document into Excel with Word Hierarchy 		 
Join Date: Jun 2016
Posts: 6
xiazai0003 is on a distinguished road
Default Cross Reference
Here are two cross links

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

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


Quote:
Originally Posted by xiazai0003 View Post
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?
Reply With Quote
  #10  
Old 06-19-2016, 04:56 PM
xiazai0003 xiazai0003 is offline Convert Word Document into Excel with Word Hierarchy Windows 7 64bit Convert Word Document into Excel with Word Hierarchy Office 2010 64bit
Novice
Convert Word Document into Excel with Word Hierarchy 		 
Join Date: Jun 2016
Posts: 6
xiazai0003 is on a distinguished road
Default
Thanks, just start to learn VBA...

Quote:
Originally Posted by Guessed View Post
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
Reply With Quote
  #11  
Old 06-19-2016, 06:16 PM
xiazai0003 xiazai0003 is offline Convert Word Document into Excel with Word Hierarchy Windows 7 64bit Convert Word Document into Excel with Word Hierarchy Office 2010 64bit
Novice
Convert Word Document into Excel with Word Hierarchy 		 
Join Date: Jun 2016
Posts: 6
xiazai0003 is on a distinguished road
Default
Quote:
Originally Posted by macropod View Post
You could just post a reply there, with a link to this thread...
Thanks!~~~~~~~~
Reply With Quote
  #12  
Old 06-19-2016, 06:40 PM
macropod's Avatar
macropod macropod is offline Convert Word Document into Excel with Word Hierarchy Windows 7 64bit Convert Word Document into Excel with Word Hierarchy Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,501
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
You still haven't posted your cross-post thinks to this thread at VBA express. Kindly do so.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert Word Document into Excel with Word Hierarchy Why is a Word document coming up as this? How do I convert? zooeyhall Word 2 10-01-2015 06:22 AM
Convert Word Document into Excel with Word Hierarchy Convert word document to pdf Catty Word VBA 1 12-11-2013 03:57 PM
Convert Word Document into Excel with Word Hierarchy Convert a word document in an empty one with backgrounds Esgrimidor Word VBA 11 12-03-2012 03:44 PM
Convert Word Document into Excel with Word Hierarchy PDF to Word(.doc) document not convert correctly gonner Word 1 09-10-2011 03:25 AM
Convert Word Document into Excel with Word Hierarchy Convert word document to JPEG. The word document may contain headerfooters vijayaram Word 1 12-30-2009 08:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:07 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft