Find Jobs
Hire Freelancers

Word Form Fields to Excel Summary (Multiple Word files)

$30-250 AUD

Closed
Posted over 7 years ago

$30-250 AUD

Paid on delivery
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.
Project ID: 11792233

About the project

9 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
9 freelancers are bidding on average $204 AUD for this job
User Avatar
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 in 1 day
5.0 (276 reviews)
6.9
6.9
User Avatar
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 You Sincerely Prameswara
$264 AUD in 3 days
4.9 (257 reviews)
6.6
6.6
User Avatar
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 read carefully your post and, even without the attached files you refer to, I have no any question; specifications are clear. Looking forward to hear from you, Kind regards, Chris (chriskerpini)
$250 AUD in 3 days
4.9 (65 reviews)
6.6
6.6
User Avatar
Hello sir I can do the work accurate perfect in your time . Thank you
$100 AUD in 3 days
4.8 (100 reviews)
5.8
5.8
User Avatar
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 project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). I can start working on your project on Monday and have your file ready in a couple of days.
$250 AUD in 7 days
4.8 (88 reviews)
6.0
6.0
User Avatar
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 in 3 days
5.0 (70 reviews)
5.1
5.1
User Avatar
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 experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$98 AUD in 2 days
4.9 (49 reviews)
5.0
5.0
User Avatar
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 in 3 days
4.8 (78 reviews)
5.1
5.1
User Avatar
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 your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities. “Moving ahead, I can dedicate 35 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.” I am mostly online at Yahoo Messenger, Google Talk and Skype. We can discuss there in details, if you are interested. I wish you'd give me this chance. Regards, Mohsan Ijaz
$235 AUD in 3 days
5.0 (25 reviews)
4.5
4.5

About the client

Flag of AUSTRALIA
Australia
0.0
0
Payment method verified
Member since Oct 14, 2016

Client Verification

Other jobs from this client

klipfolio
$250-750 AUD
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.