Geschlossen

Word Form Fields to Excel Summary (Multiple Word files)

Dieses Projekt hat 9 Angebote von talentierten Freelancern mit einem durchschnittlichen Angebotspreis von $204 AUD erhalten.

Erhalten Sie kostenlose Angebote für ein Projekt wie dieses
Arbeitgeber arbeiten
Projektbudget
$30 - $250 AUD
Angebotsanzahl
9
Projektbeschreibung

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.

Erforderliche Fähigkeiten

Möchten Sie Geld verdienen?

  • Legen Sie Ihr Budget und Ihren Zeitraum fest
  • Skizzieren Sie Ihr Angebot
  • Bekommen Sie Geld für Ihre Arbeit

Heuern Sie Freelancer an, die auch auf dieses Projekt geboten haben

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