PDA

View Full Version : Export data from Word to Excel - School Assignment



Ingvarr
05-11-2015, 12:44 PM
Hi,

I am new on this forum and a beginner in VBA. I have a school assignment:



Create a VBA macro to parse the provided sample Word document (.docx format) by following this set of rules:



Output of the VBA macro is an Excel document (.xlsx format)
Each type of Word object found in document (paragraph, heading, image etc) will be placed in Column A in the next available row in sheet1, according to the order in the Word document

Heading 1 needs to be UPPERCASE
Heading 2 and 3 need to be bold and underlined
Paragraph is left as is
Image is left as is
Enumeration is put in a single row (cell)
Table: values of column “req” and “content” should be put in the cell in format “req => content”


If there is a header, the macro will put a tag “<header>” in cell A1, and similar for footer, in last A cell.
Empty lines (paragraphs) will not be put in Excel document as empty rows
Code should have enough comments (in English) to be understandable to normal user

Any help you can give me would be greatly appreciated!

Thanks,
Ingvarr