Word Form Fields to Excel Summary (Multiple Word files)

Project Budget

$30 - $250 AUD

Total Bids

9

Project Description

This small project requires someone with some VBA skills and the basic principles of reading Word Form Fields from a MS Word file and taking this information and summarising it into a row of a spreadsheet. The requirement is for the Macro/VBA agent to work read and summarise ALL word files in the active folder in which the spreadsheet resides.

I have attached the following:

1) ImportTemplate Spreadsheet: This is the spreadsheet in which the Macro/VBA Agent should be written. Each word file in the folder of spreadsheet should have its Form Fields read and inserted into the appropriate columns - a new row for each file

2) ExcelMapping Word Document: This is a summary of which cells should be mapped to which form fields

3) Plan1-ABC, Plan2-DEF and PLAN3-XYZ: 3 Sample Word files with the standard set of Form Fields but 3 different type of content to be used as a test (or variations of this)

REQUIREMENT IN DETAIL:

1. A VBA Agent/Macro written in the ImportTemplate spreadsheet. This should do the following:

2. Insert the 'run date/time' into CELL B2

For each Word file in the folder in which the spreadsheet resides:

3. Insert the filename of the Word file (stripped of the extension) into column A (row 5 onwards). The filename would be unique and no particular naming convention so basically every filename of the Word file (minus the .DOCX)

4. Insert the ReviewDate field from the Word file into Column B

5. Insert the ReviewDate field from the Word file into Column C

6. Insert the StateBU field from the Word file into Column D

7. Insert the Company field from the Word file into Column E

8. Insert the Q1 field from the Word file into Column F

9. Insert the Q1Action field from the Word file into Column G

10. Insert the Q2 field from the Word file into Column H

11. Insert the Q2Action field from the Word file into Column I

12. Insert the Q3 field from the Word file into Column J

13. Insert the Q3Action field from the Word file into Column K

14. Insert the Q4 field from the Word file into Column L

15. Insert the Q4Action field from the Word file into Column M

16. Insert the Q5 field from the Word file into Column N

17. Insert the Q6Action field from the Word file into Column O

18. Insert the NeededToProgress field from the Word file into Column P

19. Insert the Confidence field from the Word file into Column Q

20. Insert the NextReviewDate field from the Word file into Column R

Repeat steps 3-20 for each word file in the folder, inserting the results from each word file into a new row.