-
Export data from Word to Excel - School Assignment
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
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules