Hi,

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


  1. 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
    1. Heading 1 needs to be UPPERCASE
    2. Heading 2 and 3 need to be bold and underlined
    3. Paragraph is left as is
    4. Image is left as is
    5. Enumeration is put in a single row (cell)
    6. 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