Find Jobs
Hire Freelancers

VBA Populate word document with excel value

$10-30 USD

Completed
Posted over 6 years ago

$10-30 USD

Paid on delivery
Hi there, I need help with the following I have a Word template that contains text and placeholders i.e. " Hello my name is [name], and I'm [age] and I want to be a [job] when I grow up. As I said, I'm [age] and I would like to be a [job] when I grow up, and my name was [name]." And an excel file that contains with collum A overview of all the placeholders and collum b with the value beloning to the placeholder. CollumA | CollumB Placeholder. | Value [name] James Bond [age] 16 year [job] Police agent The macro needs to do the following steps: 1) Macro needs to have a start button in the excel ribbon. 2) Once pressed, it shows some text like (Macro name, version number and start button) 3) Open word template from difned folder, that contains text with placeholders. 4) Search for placeholder in the word document and replace it with the value for in collum b of the excel. 5) Show message that macro is done. Please note the macro needs to be written in a loop, so I don't want to write code for every placeholder.
Project ID: 16065625

About the project

15 proposals
Remote project
Active 6 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
Awarded to:
User Avatar
I have done this before so I can just edit the macro I created before and give this to you in one day. Feel free to contact me about this.
$30 USD in 1 day
4.7 (66 reviews)
5.3
5.3
15 freelancers are bidding on average $32 USD for this job
User Avatar
Greeting, I have understood your VBA Populate word document with excel value task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Entry, Excel, Visual Basic, Visual Basic for Apps, Word
$30 USD in 1 day
5.0 (301 reviews)
7.7
7.7
User Avatar
Hi, I ll code the macro as per description. But I need to check your Word template before. As we need to give a name for each fields so it can be called and filled by the Excel macro. Thanks
$50 USD in 2 days
4.9 (282 reviews)
7.5
7.5
User Avatar
Hey There, I have done excel->word/pwerpoint/outlook. Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/word/outlook VBA automation professional having 7+ years of experience and can do it with the required quality. Next steps: Lets discuss/validate the complete requirement, budget and I can start to get this done with required quality output. Lets discuss more online on chat. Thanks, Aman
$50 USD in 0 day
4.9 (173 reviews)
6.5
6.5
User Avatar
hi, can you please send me your word file in chat?
$50 USD in 1 day
4.9 (194 reviews)
6.3
6.3
User Avatar
Hello I have read and understood the requirements. I can hep you build this macro. It is a simple find-replace-save as procedure. I can make it behave exactly as you need to. You will click the button and copies of the populated word documents will be saved in the working directory. I have a lot of experience working on VBA projects. Don't hesitate to contact me with any question you might have. Thanks for reading, Michael.
$30 USD in 1 day
5.0 (32 reviews)
4.3
4.3
User Avatar
quick question. excel file has records for only one person?
$30 USD in 1 day
5.0 (13 reviews)
3.7
3.7
User Avatar
being an engineer i believe i can do the job in better way.
$30 USD in 3 days
5.0 (2 reviews)
2.2
2.2
User Avatar
A proposal has not yet been provided
$35 USD in 2 days
5.0 (1 review)
2.3
2.3
User Avatar
For 6 months i have worked as data scientist so i have done some office projects on excel VBA they are easy
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I will do this work, because am having good ms word, and ms excel skills to complete this work as early as possible thank you
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$15 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I m expert in excel so fully justice with your work Relevant Skills and Experience Yes I have 5 years experience in MIS
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have completed master in computer applications which is MCA in my home country. I am very well aware of .net technologies, so I am fully assure that I can complete this project. Thanks.
$20 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NETHERLANDS
Amsterdam, Netherlands
5.0
4
Payment method verified
Member since Sep 26, 2015

Client Verification

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.