关闭

Word Form Fields to Excel Summary (Multiple Word files)

该项目收到9 来自天才威客的竞标,平均竞标价格为$204 AUD

为像这样的项目获取免费报价
雇主工作
项目预算
$30 - $250 AUD
全部竞标
9
项目描述

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.

在寻找赚取金钱的机会?

  • 设定您的预算和时间框架
  • 大致描述您的建议方案
  • 为您的工作领取工资

雇用同样在该项目上竞标的威客

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online