Word Form Fields to Excel Summary (Multiple Word files)

Cerrado

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.

Habilidades: Excel, Visual Basic para aplicaciones , Word

Ver más: pdf form fields word, word excel form comparison multiple product cost presentation, including form fields word pdf conversion, copy form fields word excel, copy form field word excel, word fillable form fields repeat, convert word document excel form, vbs import multiple files excel, transfer excel html form fields, automatically import data multiple files excel, convert word form fields pdf, importing multiple text files single excel spreadsheet, convert word form pdf form fields, fill multiple form fields ajax autocompleter, mysql search multiple fields word

ID de proyecto: #11792233

9 los freelancers están ofertando un promedio de $204 para este trabajo.

cgullapalli

Hi, I am good at Excel, word and vba. Please provide me the excel file or i need to create the format as required. Looking forward to discuss in the chat.

$150 AUD en 1 día
(276 comentarios)
6.9
chriskerpini

Hello, My name is Chris and, as you can see from my profile, I have 16+ years experience working with Excel/Word/VBA and 13 years teaching them (all levels). I certainly can do excellent work with your project. I re Más

$250 AUD en 3 días
(65 comentarios)
6.6
prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can do copy paste your data from Word into excel via VBA macro :) please giveme a chance for doing your job and im able to start doing your job right now Thank Más

$264 AUD en 3 días
(257 comentarios)
6.6
Harun1986

Hello sir I can do the work accurate perfect in your time . Thank you

$100 AUD en 3 días
(100 comentarios)
5.8
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr Más

$250 AUD en 7 días
(88 comentarios)
6.0
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Más

$98 AUD en 2 días
(49 comentarios)
5.0
tasleem83

I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start

$250 AUD en 3 días
(78 comentarios)
5.1
vlayausa

Hello, I am proficient with Excel and VBA and I would love to help you with this project. Please contact me for more information.

$236 AUD en 3 días
(70 comentarios)
5.1
MohsanEijaz

I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y Más

$235 AUD en 3 días
(25 comentarios)
4.5