Thread: [Solved] Macros to convert text to Table
View Single Post
 
Old 08-28-2015, 09:11 PM
gmayor's Avatar
gmayor gmayor is offline Windows 7 64bit Office 2010 32bit
Expert
  
Join Date: Aug 2014
Posts: 4,137
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
I don't think it is possible to come up with a solution that will convert the document to a table.

The document is formatted using frames to make up the columns. If you processed each frame separately, even in this extract the data is split between frames e.g. the first part of the second frame belongs to the end of the last part of the first frame.

If you remove the frames it creates a different set of problems.

The individual segments are not consistently formatted. Some have multiple paragraph breaks within a segment, others have different amounts of information.

I regret I can see no way to make this task easier using vba.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote